Hi,
I have an unbound search text field on my form and beneth that a dropdown box that the user can select the field they wish to search. I have the queries in place that use the details in the textbox to produce results, what I need is help with the code that says if the drop down box equals customer name then it uses the 'customer name' query.
At the end of the day I want users to be able to type in what they are searching for, select the field (from the drop down box)that this search applies to and hit the go button to make it happen.
Any help would be grately appreciated.
I have an unbound search text field on my form and beneth that a dropdown box that the user can select the field they wish to search. I have the queries in place that use the details in the textbox to produce results, what I need is help with the code that says if the drop down box equals customer name then it uses the 'customer name' query.
At the end of the day I want users to be able to type in what they are searching for, select the field (from the drop down box)that this search applies to and hit the go button to make it happen.
Any help would be grately appreciated.