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 fields 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