How to restrict Form to 1 product.

  • Thread starter Thread starter ThomasAJ
  • Start date Start date
T

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.
 
In the Click event of the button on FormA, a bit of code like:

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