Search form based on option group option
Posted on 2011-09-27
Hi. I'm not a newbie to Access but not sure how to do this. I have one unbound textbox called 'text1" in the control. I want to search by multiple things based on the answer in an option group. For instance, the one search field and say 3 option group options based on a table or query. The 3 option groups are "search by ID", "search by name" or "search by city."
I want Access to be able to search the right field and pull up the correct results based on what the user has chosen. I think I saw this someplace in a sample Access database but I can't find it on the web anywhere. If no options are chosen, I want all records. If the first option is chosen of "search by ID" and they type in "12" in the textbox, I want everything with "12" to come up in the search results.