This DB is for my video game collection.
Here's my issue. I made a search box and button in my MAIN FORM and the button holds the macro APPLYFILTER.
In it, I have the following string: [ConsoleName] Like '*' & [Forms]![frmMain]![Search_Box] & '*'.
I then type NES and GENESIS and SNES also show up along with NES results.
I do not want to have multiple queries for each console and would like to run all my queries from a single one. How should I do this to make the search specific to each console without having multiple queries for each console? Thanks.