About synchronizing records between two forms

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.

You can also use the Form Wizard to create two related forms from scratch.