Challenge including the double quotes to use in Find Method

Joined
Feb 8, 2009
Messages
15
Reaction score
0
Hi

I am using Find Method in Access 2007. Since Find method needs the Column name with double Quotes, Current Challenge am facing is including the double quotes along with the column name
The column name being dynamic taken from variable. Else when hardcoding the column string this works fine.

strColumn = "ContactID="
strValue = 33

rs.Find " " " & strColumn & " " " & strValue

Want to achive
rs.Find "ContactID=" 33

I have tried
strFind=" " " & strColumn & " " " (the output stored in the strFind variable is not as expected)

Thank you
Regards
Knight
 
Back
Top