I am attempting to use VBA to get a continuous form to open using a wildcard query. Specifically, I am trying to set things up so that the user inputs a search term (partial company name) into a textbox on a form and by clicking a "search" button opens a continuous form with matches to the search term (in any position). I have tried the following code which opens the form, but no search results appear:
DoCmd.OpenForm " CF_Companies", , , "CompanyName Like '*" & SearchTextBox & "*'"
I have also tried numerous variations of the above, but alas only get synthax errors. Can anyone help point me in the right direction ? Thank you !