Create simple form to add a record

  • Thread starter Thread starter Z
  • Start date Start date
Z

Z

I'm a new Access user. I have a table and want to create a simple
form that will allow me to add records to the table. I have all the
appropriate text boxes on the form, but how do I actually get the form
to input data into the table? TIA.
 
You can use the form wizard to create the form,
alternatively use your current form and in design view
show the properties window. In the properties there is a
property called RecordsSource. When you select this you
can chose from your tables and queries what source you
will use. Select your table. Then for each form control
(text box, check box, etc) you need to change the control
Source in the properties window to the relevant field in
your table.
 
Access will save the data to the table automatically when
you go to a new record on the form or you close the form.
 
Back
Top