I had a good thing going with a text box and a listbox for a user to use to search. Now, instead of the list box I was wanting a subform. Thought it would look better. I'm literally going around in circles trying to figure out where the problem is (other than myself).
Main Form: frmSearch
Subform: subSearch
Search Text Box: txtSearch
Query: qrySearch
As from the image above, I want the user to be able to search by Account Name or the City. When I beging to type in the search box, nothing happens. But if I exit out of everything, click on either the search query or the subform I of course get the Parameter Value Message.
But the query/subform work if I input the some or all the data in the message.
Heres the YouTube link Ive replayed over and over trying to figure out what Im doing wrong. I believe I followed this to a "T" and I still get nothing.
How to filter a subform from a textbox on main form (MS Access) (youtube.com)
What am I overlooking?
With the SQL, I tried the "Like "*" & [Forms]![frmSearch]![txtSearch] & "*" ", one without the Forms syntax, ive tried with and without brackets. I'm tapped.
Ive tried using/not using the Yes/No in the Properties section of the query "Output all Fields".
Do I need to put the "Like" syntax in with the sub as well? I feel that would be redundant as well as confusing. Just throwing it out there