how to create a form where user inputs data and then saves to tables?

[Daniel B]

I have tried creating a subform where all the data from the tables is present, therefore the user will have to enter information for a new record into each field. This did not allow me to enter data for some fields, and i was not able to save it into each table.

The data is stored in 7 tables, and I cannot figure out how to create a form that will allow me to enter data in a new record and then save that data into the appropriate tables.

Is there an easier way to create a form where the only thing you can do is enter data for a new record and then be able to save that data into the original tables?

[mshmyob]

Create a select query with all the fields you want to use from all the tables and then bind the subform to the query. You will then have access to all the fields you need.

cheers,