You might often want to look at related records on two forms at the same time. For example, while looking at a customer record on a Customers form, you might want to open an Orders form that shows the customer's orders.
When you move between records on a form, you might also want to automatically view related records on a second form. For example, as you move between supplier records on a Suppliers form, you might want to see the products each supplier carries in a Products form.
You can synchronize records between two forms by creating a command button that opens and synchronizes a second form, or by using the Current event to display related records on the second form when you move between records on the first form.
Tip You can also use the Form Wizard to create two related forms from scratch. In the first screen of the wizard, select fields from two different tables. In the second screen, click Linked Forms. The wizard creates the two related forms; each form contains fields from one of the tables. One of the forms also has a command button that opens the other form and synchronizes the records between the forms.
Create a command button that opens and synchronizes a form
Display related records in one form when you move between records on another form