using like operator with FindFirst

[MikeyS]

Hi All

I have an unbound text box used to put in data to search through surnames activated on the onchange event. I'm using findfirst with the like operator. I can get it to work with the wildcard symbol located on both sides of the text box as shown below

 Me.RecordsetClone.FindFirst "[Surname] like ""*" & Me.txtSearch & "*"""

However I only want the wildcard at the end of the text box but I can't get the syntax correct as shown below:

 Me.RecordsetClone.FindFirst "[Surname] like (me.txtSearch & " * ")"

Any help would be appreciated

Mike

[zmbd]

I don't have the editor open right now and I'm on my way out of the office; however, your syntax appears to be off. Try the following:

Me.RecordsetClone.FindFirst "[Surname] like '" & me.txtSearch & "*'"

Normally I buld these strings first and then insert them into the functions as the string are much easier to trouble shoot when you can see the resloved value.

[MikeyS]

Hi zmbd

Tried your syntax but says method or data member not found. Any other ideas we must be close

Mike

[Rabbit]

Did you copy z's code exactly? Because that won't work. Z used textSearch while your previous code indicated the control is actually named txtSearch.

[zmbd]

Opps sorry... (blush)
I just got home and logged in to see what happened.
However, I did mention that I was on my way out-the-door :-)

[NeoPa]

It seems you missed out the opening quote after the Like keyword. Actually, the quotes are better done as standard SQL quotes ('), but doubling the double-quotes (") works too (See Quotes (') and Double-Quotes (") - Where and When to use them) :

Me.RecordsetClone.FindFirst "[Surname] Like '" & Me.txtSearch & "*'"

[MikeyS]

Thankyou everyone for your help. The final syntax got us across the line and thanks Neopa for the reference to the article as well.

Mike

[NeoPa]

Always a pleasure Mikey :-)