Linking Access Tables/forms
October 31st, 2009
I have a Access 2003 database in which the main form has 10 not yet filled tabs. Each of these tabs need to contain a different form which is linked to the record (all 10 forms look the same, with the same table structure underneath both they all represent a different year).
The 10 sub-forms are already created including the table under there.
These are the things I want to have done:
- Insert and link the 10 forms/tables as sub-forms into the tabs of the main form/table so the correct year info is displayed by the record.
- When a user makes a new record this is done by a different form that makes the record in the main table. I want the 10 sub-forms/tables to automatically get a corresponding record there.
