 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2005bound text
I created a form in access by creating my textboxes and naming them as I created the form instead of creating the database first and then bounding them to the form. Right now I can't scroll through my records on the form even though I can enter new records and save them to the database. I can't display or scroll through the ones I've entered on my form. Olease Help. If you want to bind an already built form to a RecordSource, go to the data tab of the form properties and add the RecordSource by choosing from the table/query combo or by typing in an SQL string. Once the form is bound, you can modify the ControlSource for each control to choose the appropriate field from the form's RecordSource. > I created a form in access by creating my textboxes and naming them as I > created the form instead of creating the database first and then bounding > them to the form. Right now I can't scroll through my records on the form > even though I can enter new records and save them to the database. I can't > display or scroll through the ones I've entered on my form. Olease Help. >I created a form in access by creating my textboxes and naming them as I >created the form instead of creating the database first and then bounding >them to the form. If you were building a house, would you assemble the walls and windows first, and then start pouring the foundation? You're doing things backwards! >Right now I can't scroll through my records on the form >even though I can enter new records and save them to the database. I can't >display or scroll through the ones I've entered on my form. Olease Help. Open the Form in design view, and check its Recordsource property. This should be either the name of the table which is to contain the data, or a Query based on that table; it should include all the fields that you need. You'll probably also need to go through all the controls on the Form and set their Control Source property to the name of the table field into which the entered value should be stored. John W. Vinson[MVP] Also check that 'Data Entry' in Form Properties is set to 'No' > I created a form in access by creating my textboxes and naming them as I > created the form instead of creating the database first and then bounding > them to the form. Right now I can't scroll through my records on the form > even though I can enter new records and save them to the database. I can't > display or scroll through the ones I've entered on my form. Olease Help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.