bound text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
Click to expand...

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.
Click to expand...

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]
 
Back
Top