View Single Post
Old June 7th, 2010, 08:38 PM posted to microsoft.public.access.queries
vander via
external usenet poster
Posts: 5
Default Using a combo box to determine which field to search.

What I want to do, hopefully, will be simple enough. I want to have a search
form that has two fields, one a combo box and the other an unbound field. I
want the combo box to list the different fields within a table that I want to
search. I want the unbound field to be where I enter the criteria for
searching the field that I selected in the combo box. In the past I usually
just created an unbound form and created unbound fields for each field and
then call the fields to the query. This has always worked well enough but
thought It would be easier using 2 fields as opposed to many. Any help would
be greatly appreciated.

Message posted via