steve_4477
Registered User.
- Local time
- Today, 05:26
- Joined
- Jan 10, 2011
- Messages
- 23
Hello-
I need help tweaking this criteria. I have a form with a combo box with 3 options. Once the user has selected this parameter, they proceed to enter text in the search box and click a search button. I also have a list box displaying results. Obviosuly the query behind the list box is based on the two previously mentioned parameters.
I know how to set up the search for anything entered in the text box i.e. the list box would return all records where the string was contained in any of the 3 fields:
Criteria: Like "*" & [Forms]![RM_Search]![SearchFor] & "*"
~Entered as criteria for each field on a seperate line.
I'm having an issue when the dropdown parameter is selected. How do I query only based on the parameter selected from the combo box- does this make sense and any ideas??
I need help tweaking this criteria. I have a form with a combo box with 3 options. Once the user has selected this parameter, they proceed to enter text in the search box and click a search button. I also have a list box displaying results. Obviosuly the query behind the list box is based on the two previously mentioned parameters.
I know how to set up the search for anything entered in the text box i.e. the list box would return all records where the string was contained in any of the 3 fields:
Criteria: Like "*" & [Forms]![RM_Search]![SearchFor] & "*"
~Entered as criteria for each field on a seperate line.
I'm having an issue when the dropdown parameter is selected. How do I query only based on the parameter selected from the combo box- does this make sense and any ideas??
