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.