If so, then you can either use a parameter query or construct the query (with SQL) in VBA code. You can get the SQL code from the query grid by switching to SQL view.
Meanwhile, if 15 youtube videos haven't helped, is it because they don't really address the problem, or because you don't understand them?
If the latter, then how are we to magically explain it any better using just text? You may have to work harder to dissect exactly where YOU are having the difficulty.
I am trying to create a search option is a form in 2010 MS Access. It is for a DVD collection so the fields in the Table are obviously title, genre, rating, year and location. I want to be able to type any of these criteria into a search box and get a result even if it returns multiples. I also need it to give me a message if what I am searching for isn't in my collection. This is driving me crazy and I have watched 15 You Tube videos and gotten no where. Please help
