CODEWITHSUNDEEP
ms-access
adlan
adlan

Reputation: 61

I want to open another form based on another form value in Access

Hello I have a form in access that drop list value. "Transer","Promo", and "New". If the user choose transfer or promo, it will open another form call old info and in that form it should transfer the same ID that the user entered first time. Can anyone help me please

Upvotes: 1

Views: 3023

Answers (1)

Robert Harvey
Robert Harvey

Reputation: 180908

DoCmd.OpenForm strMyFormName, , ,"ID = " & intMyID

http://msdn.microsoft.com/en-us/library/aa220276(v=office.11).aspx

You can access the value you passed in intMyID using Me.OpenArgs.

http://msdn.microsoft.com/en-us/library/aa160845(office.10).aspx

Upvotes: 2

Related Questions