rickbytes said:
I have a form that has already been created, and a table that has
already been created. Both contain the same field names.
I want to be able to enter inormation in the form and have it
populate the table with the information entered on the form.
At the current time the fields in te form say "unboud".
How do I go about this task.
Normally one would create the table first, and then create the form,
basing it on the table so that you could just drag fields from the field
list (in design view) to have all the table and field linkages work
correctly. Unfortunately, since you didn't do things in that order, you
now have to do it the hard way and bind your controls manually.
Fortunately, it's still no big deal.
Open the form in design view, and open the property sheet for the form.
On the Data tab of the sheet, enter the name of the table in the Record
Source property. There, the form is no longer unbound.
Now click on each data control in turn (that is, those that should be
bound to fields in the table), so that you can edit the property sheet
for the control. In the Control Source property for each of these
controls, enter (or select from the dropdown list) the name of the field
to which it should be bound. There, now that control is no longer
unbound. When you've done that for all the controls that should be
bound to fields in the table, you're done.
