I have a query that works great and one that doesn't because I guess they work slightly different. The one that works great is a split form with an unbound text box with a filter button. This is what I have in the VBA editor:
Me.Filter = "[Recorded By:] Like '*" & Me.txtFilter & "*'"
It filters anything I type as if having a wild card at the front and end of the data I enter. This is what I want for my other query but can't seem to get it to work. I have this expression for a query in design view for the criteria parameter:
Like [Forms]![Partial Criteria].[txtPermit] & "*"
I'm pretty sure it has something to do with the * because I noticed the top VBA has an * with an & character before and after the text box but I'm not sure how to rewrite this for the bottom expression. Can someone assist with this?
Thanks so much.