How can I create a multiple field search box that use logical operators in an option box?

[suleyman.mutuwa]

Hi,
I need assistance in creating a multiple field search box, i have a
screen shot but i couldn't find a way to include it in this message.
I have been battling with this problem for weeks.
I'm trying to use ms access 2003 to create a search box similar to
one i saw in foxpro. It searches all the fields in only one table so
each
table has a search box for it. Here is a description for the search
box for the community table which is one of the tables in the
database.
It has a drop down list that selects all the columns in the table
such
as area code for the community, community code, and community
description. Beside it is another dropdown list box for operator
which you can use to select operators such as plus, equals to (=),
greater than, less than, is null, between, in.
beside this is a box that display value.
Below all of these form fileds is an option box with options for and,
or.
and beneath this is another row just like the one before the options
box.
Below theses are three buttons for search, all, cancel. What's really
hard for me to figure out is the option box that uses AND, OR to
combine
the two diffrent search groups.
I'd be glad to send a screen shot to anyone who requires it to assist
me.
Thank you

 

[Steve]

Your serch form provides the criteria to a query that returns the record
that match the criteria you choose. So for the area code field in the query,
use the following expression for criteria:
Forms!NameOfSearchForm!AreaCode Or (Forms!NameOfSearchForm!AreaCode Is Null)
Note: AreaCode is the name of the field on your search form where you
enter/select the area code. Use a similar expression for all your search
fields.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)