updating multiple tables on a form

[Guest]

I am designing MDB where I update multiple tables from one form. Is there a
template for this? I keep getting too many fields and can't create the form.
Basically I have one unique key that each of the table has (normalized mdb).
Each section(sub form?) contains common information. I want to be able to
enter the new record and update the multiple tables that store the
information, then edit/change/update the information over time. Can I do
this one one form using a tab approach? Each tab represents a subform that
is associated to one of the tables.

 

[Rob Oldfield]

Sounds like it should work. If you're getting too many controls for the
form to be usable then I'd think about just displaying the key ones on the
main subform(s), with the others available via a linked form. (e.g. if you
have a personal details subform, then just display name, phone, address
immediately, with a button to pop up another form that allows the favourite
colour, hat size, name of dog etc fields to be accessed.