Creating search function same as the search button in class searchform

[jerold]

Hello!
I would like to create a form with search capability.
I have a source of predefined fields in a combo box to be
searched. How would I create a search button that would search the records with the criteria of combination of the fields/options selected. I have created checkboxes for the fields to be searched.

 

[foxdev]

Are you searching all of the checked fields for the same value, or does each checked field have its own value to search for?

Basically, the approach is that in your cmdSearch.Click you'll have a whopping CASE construct that looks to see which fields are checked, then build an SQL SELECT command string programmtically. After examining the possibilities and building your search string, you execute the search string with DoCmd or macroing.