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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
Update record form help 1
How to pause for input in a while loop 5
Maximize Form 4
Windwithme COMPUTEX 2024 Connecting AI new products shared with ShowGirls 4
Passing data from one form to another 1
Oop's I did it again! 5
Set Focus to a null value in a continuous form 1

Back
Top