Coding help for a main menu list...

[breaker11]

I just needed some tips on writing a code for a main menu. Right now I have a main menu with a complete list of all records ordered by the product name, but when a specific record is double clicked, it opens the first record in the database rather than the one being clicked. What do I need to add to my code that would do the trick? Any suggestions are greatly appreciated, here is what I currently have on the main menu:

Private Sub List0_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "realdeal"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

Thanks again.

 

[DougP]

you need to put a value in here > stLinkCriteria
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "yourfieldname = '" & me!doubleClickTextbox & "'"
stDocName = "realdeal"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive