Need help with DoCmd.OpenForm

[accessturtle]

Hello

i have been trying to use this code but for some reason it giving me an error 2015. I have a form that contain my posible match for the search criteria and for me to open the my selection i double click on it and its opens in a new form. this has been working with my previsou databse but for some reason its not working on the new one. i did all the nessassary changes. VBA code is

Private Sub List6_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmManualEdit"

stLinkCriteria = "[contr]=" & Me![List6]
DoCmd.OpenForm stDocName, , , stLinkCriteria, , , "Edit"

End Sub

 

[boblarson]

Is contr a numeric or text field?

 

[accessturtle]

thank you soo much for your quick reply.... i am soo silly i missed the basic step... it was set as text LOL

blond moment, its working fine now

thanks again

 

[boblarson]

Glad you got it working.