Filter with wildcard

[gg80]

I can't seem to do the simple feat of filtering with a wildcard. I have a combo box in a continuous form's header. The user may modify the full combo box selection as wished.



What I am trying to achieve is: OnUpdate, if the combo box displays "Sm", I would like the form to filter for smith, smythe, smolen etc. The last I tried was Form.Filter = "[lname]='" Like "*" & Me.FF & "*" & "'"

Must be simple, but I have tried all the "Like" expressions I can find on this site and elsewhere and am going nuts missing something. Using A2007 with W7. Any help appreciated.

[TheShabz]

Try
"[lname]= Like " & Me.FF & "*"

[gg80]

HI - I tried Form.Filter = "[lname]= Like " & Me.FF & "*" per suggestion, but I get error message as follows: Run Time error no 3075 Syntax error(missing operator) in query expression 'Lname= like sm*'. Is it my computer?

[TheShabz]

No. It's the fact that I had on my Concept hat and not my Syntax hat.
Form.Filter = "[lname]= Like """ & Me.FF & "*"""

[Toyman]

HI - I tried Form.Filter = "[lname]= Like " & Me.FF & "*" per suggestion, but I get error message as follows: Run Time error no 3075 Syntax error(missing operator) in query expression 'Lname= like sm*'. Is it my computer?

take out the equal sign "=" and add single quote before the quote sign after "like" and single quote after the "*"

"[lname] Like '" & Me.FF & "*'"

[TheShabz]

Guess I picked up the wrong hat again. =/

[gg80]

Thanks everybody. If it weren't for this superior forum, I might commit hari-kari. This now works- I won't even try the one with asterisks in front for a while. Why do these expressions have to be so non-intuitive? Thanks again.

[TheShabz]

compared to other programming language, VB/VBA is VERY simple.

Also, I believe it's called harakiri or seppuku.

[gg80]

I stand corrected. The only other programming I did, before Gates was born, was regular basic. As I remember it, very intuitive.