Updating multiple tables form single form

[mcdhappy80]

Can I put several subforms on main form, and then from that main form enter the data in the subforms (each subform has different table as data source) and thus add the data to different tables?

Thank You.

 

[Chris1112]

You should have no problems doing this. The data can get a little hard to look at if the information is not related in some way though, in which case you need to link the subforms to the main form.

 

[mcdhappy80]

You should have no problems doing this. The data can get a little hard to look at if the information is not related in some way though, in which case you need to link the subforms to the main form.

What do You mean by "hard to look at"?
All the tables are in relation to the master table which is the data source to master form. What I am trying to do here is cut the need for multiple forms (for each table) by putting all in one place.

What I want to do next is create a button which I will click after entering data, and which will update the new record for each table. How do I do this (with VBA)?

The subforms will each be linked to the main form by the foreign key fields in the master table which is data source for main form.