forms to table

  • Thread starter Thread starter brandnewuser
  • Start date Start date
B

brandnewuser

I need to move the data from a form - checkbox, description, dates to a
table. I have the form created. I have a submit button - which needs to
submit to the table.

HELP!!
 
Hi brandnewuser,
yes it is quite a struggle if you build the form first.
Usually we build the table first.
Do you have a table already for the information to go into?
If you have a table, then you can make the table the recordsource for the
form.
On the form's property dialog, choose the Data tab.
Find the property called Record Source, select the name of the table from
the drop down for record source.
Save the form.
Now to make the information go into the table when a user types in the
controls on the form, you need to set up the control source for each control
that the user can enter a value in.
Bring up the property sheet for the first such control, go to the data tab
and look for the property called Control Source.
If you click on the dropdown for Control Source, you can select from the
list of fields in the table.
You need to do this for each control that the user can edit.
Once again save the form.
Now it is time to test the form to see what else is needed to make it work
properly.
Open the form in normal view and try to add some info.
After you add some info, close the form and check what info got saved to the
table.

Post back when you need to.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top