How to restrict Form to 1 product.

[ThomasAJ]

I want to open FormP from FormA.

I want to restrict FormP to ONLY show 1 Product - so how do I 'feed' the
product number from FormA so FormP shows only that product and has bound
controls to the Product Table so that changes made in FormP update the
Product Table.

 

[Arvin Meyer [MVP]]

In the Click event of the button on FormA, a bit of code like:

DoCmd.OpenForm "FormP",,, "ProductID =" & Me.txtProductID