Get ProductId field from another form

[DavidCantor]

can anyone tell me how do I get the ProductID value in one form to show on a different form when the second form is opened.

i have two joined tables with ProductID as the PK on both.

thanks

 

[pbaldy]

This?

http://www.baldyweb.com/wherecondition.htm

Or you can place the value in the second form after it's opened:

Forms!SecondFormName.ProductID = Me.ProductID

 

[Trevor G]

Create a macro that opens the second form then at the bottom place in the actions which form etc and at then add the Condition which would be the form and ID field you have on the form you have open which is then equal to the table where the other ID field resides

Forms![frmReservations]![ID] = [tblReservations]![ID]