Quick Question (condition syntax error)

[pheidlauf]

Hello. I'm receiving a "Error 3464" data type mismatch error from the code below.

DoCmd.OpenForm "AllEmployees", , , "[OPERATOR_ID] =" & (Me![SearchResults])

OPERATOR_ID is a text primary key (from the network, not my creation), and SearchResults should be returning a string as well. I don't know where the issue is.

Help please? Let me know if any further information is needed.

 

[pbaldy]

This should help:

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

 

[pheidlauf]

Thanks for the help! It works now. For anyone having the same issue, here is the code that works:

Private Sub SearchResults_DblClick(Cancel As Integer)

DoCmd.OpenForm "AllEmployees", , , "OPERATOR_ID='" & Me![SearchResults].Value & "'"

End Sub

 

[pbaldy]

Happy to help!