If I understand your correctly, you could use one or more unbound
combobox(es) in the header of a single-record style main form to select &
display a specific case file. Use the toolbox combobox wizard and follow
its prompts to "find a specific record". You could use one of these for
each of the sort/filter criteria you want to use, or more elegantly use a
single combobox and an option group to select which query to use for its
control source.
-Ed
"Marina" <ma*********@earthlink.net> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...
I would like to create a search for that is based on the CaseFiles
query and have no idea how to go about this. I would like the user to
be able to search by CaseNumber, FirstName, LastName, or ClientID.
Any help would be much appreciated.
Marina