Use combobox to search multiple fields

G

Guest

I have a form displaying a number of fields I may wish to filter using a
combination of a combobox and textbox.

The problem I have is that I need to be able to search on a number of
different fields at different times. e.g. search on field 1 sometimes and
maybe on field 2 othertimes.

Is it possible to use a combobox to select the respective field to search on
(using combobox row/source set to Field list) followed by a textbox to enter
the search string rather than having 2 textboxes specific for each of the
fields I want to search on. The use of a combobox listing the fields on the
form will also allow me to search on any selected field and keep the form
relatively tidy and uncluttered.

Many thanks
Dave.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top