Brian has attended:
Access Advanced course
Access VBA course
Forms and multiple tables
How do you create a form which is generated from two or more tables
RE: Forms and multiple tables
Create a form using the wizard.
Select the first table in the Table/Queries combo box
Select the fields to be viewed in the form
Repeat for the second/third tables
Complete the form wizard as normal
Alternatively create a separate form for each table and combine the forms in a separate new form using either the SubForm or Tab controls.
Carlos