Link between forms

[priac]

I have two tables. One is Inventory and the other is repair. I have the relationship set on the barcode for both tables. If I use a subform within the main form everything works great, but the page is too clutered. I want to use a command button to open the repair form, but the child parent relation doesn't work. How do I make the other form work as if it were a subform.

Aubrey

 

[fwatanabe]

Hi Aubrey,

Your code on the command button can do this, if you like:

DoCmd.OpenForm "Repair", , ,"Barcode = " & me!barcode

This will open the repair subform with only the record that matches your Inventory record.

Hope this helps,
Fuyo