Finding a specific Record in Inventory

[dragonmanUSMC]

Greetings all, I have a DB that is used to process customer orders. When the user is filling out the order there is a subform with the order details. (Product being ordered) The user will select a product from the drop down list. If the user double clicks the drop down field it will open the Inventory Module. What I would like to be able to do is double click the field and go to the inventory module and see the product they have selected. So the order will go like this
1. They select the product
2. They double click the field to go to the inventory module and see all the details of that product. Price, Qty, Desc., etc...

Thank you in advance for any assistance.

 

[MajP]

First do not use the term module it is confusing, it means something very different. A module is a block of code.
How do you want the interface? If it is opening another "Pop Up" form then something like. Look at the openform action in the help file.

Private Sub cmbo_DblClick(Cancel As Integer)
DoCmd.OpenForm "formName", , , "[fldName] = " & Me.productID
End Sub

 

[dragonmanUSMC]

thank you for the reply I will try your suggestion