Synchronizing of two forms (1 Viewer)

[HL]

Help Needed!!!!!!

I have created two forms; the 1st form is based on the customer’s business details known as FrmCustomers and the second form known as [FrmPATTesting] is based on Portable Appliances that the customer owns.

There is a relationship between the tables and the relationship is known as Customer ID.

To view the second form, I click on a button and form appears.

But the problem that I am having is. If I have the [FrmCustomers] open and I am on Customer ID 5 and I want to view the form [FrmPATTesting] for the customers Portable Appliance details, it is always on Customer ID 1

How do I synchronise the two forms to show the same Customer ID, remembering I might need to enter data on the second form [FrmPATTesting].

If you can help, it will be much appreciated.

HL

 

[Travis]

Part of the Docmd.OpenForm function is a Filter command, by placing the appropriate info in this area it will limit the Form to the Customer:

IE: "CustomerID=" & {YourCustomerID}