use forms for data entry to update records

  • Thread starter Thread starter Rachel Stern
  • Start date Start date
R

Rachel Stern

I have created a tabbed form. I know how to create a
form using a wizard and it automatically connects the
form to the table on which it is based and thus updates
the table when the form is used for Data entry. however,
since I am using a tabbed form, the main form (first page)
must be created inherent to the tabbed form. So, that
means I must create the form manually. How do I set the
properties so that the form elements (input fields) will
update the table?
 
Rachel,
First create a query for all of the fields that you want
to see on the form. Save the query. Then in forms design
window, show the properties window. Go to the Data tab of
the properties window and drop down the Record Source
property and select the query that you created. In the
View menu, click on the field list menu item and you'll
be able to drag and drop your fields on to the form.
I hope that helps get you started.
Geof.
 
Back
Top