Open subform based on current record
Posted on 2012-12-27
Can someone offer some guidance here?
I have a primary form and a subform already created. I want to place a command button into the detail of the primary form to open a subfrom based on the current record.
I assume I am going to use the Open Form method to accomplish this, however I am having difficulty understanding how to create the WHERE statement.
Both forms are based on primary keys using the same data "Item_Nr".
Form One details "item_Nr" and other information based on header selection
Form two details "Item_Nr" and other information based on a query from numerous tables.
Thanks for any help offered!