How can I create a multiple field search box? (corrected post)

  • Thread starter Thread starter pointer
  • Start date Start date
P

pointer

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.
the search box was created in foxpro, i'm trying to create a similar
search box in ms access 2003. it searches 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 this are three buttons for search, all, cancel.
I'd be glad to send a screen shot to anyone who requires it to assist
me.
Thank you
 
Allen Browne already answered your question, and you responded to his answer
7 minutes before you posted this.

Was there a reason for the repost?
 
Allen Browne already answered your question, and you responded to his answer
7 minutes before you posted this.

Was there a reason for the repost?

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)






- Show quoted text -

Hi, Allen brown pointed out to me that i had typed my message in upper
case. So i deleted it and reposted the same message again in small
type as a correction and also because i'm still open to other
suggestions.
 

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

Back
Top