Search multiple fields using check boxes or option group

[ficky]

I am using MS Access 2010 & 2016.


It is my first time learning using MS Access and VBA. In the database, I did a search using SQL query with 1 text box searching 7 fields. Plus, I would like to try to search selected fields(one or more) using option group or check boxes. Additionally, there is "Enter parameter value" pop-up that I would like to get rid off.


I can't seem to find any solution so I ask here. I really appreciate your help and thank you in advance.

[ranman256]

1 box for 7 fields:
make 7 queries that use the text box.
put all queries into 1 UNION query, run the union query
or
put all 7 into a macro, then run the mac to search 7 fields.

the ENTER PARAM value is because your query has a field that does not exist, or a field misspelled, or an actual param in criteria.
when this happens, the query will ask for a param.

as for selecting 1 or more fields to search:
either do a LOT of programming
or
just use a manual query design to do it yourself.

[orange]

Check some of the links at the bottom of thee screen -- under Similar Threads


This free video from DataPig deals with OptionGroup

[Gicu]

Your parameter prompt when opening the SearchForm is caused by the misspelled form name in the query for the subform (qry2018) - in the query you have Forms![Search]![txtSearch] but your form is called SearchForm. Your search in the 7 fields should work as you planned with the staggered criteria in the OR rows.


Now for the other search you don't really give much info on how you want that to work. You could use the AfterUpdate events of the checkboxes and option group to apply (and remove) filters to subform (search this forum or google it on how to do that).

Cheers,
Vlad