asked on
Morning Everyone,
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!
MC
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!
MC
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.