Select records from 6 combo boxes

S

Shiva

Hi,
I am in urgency to create a form having 6 combo boxes on it which is
supposed to select data from a table containing a huge data. I want to add a
click button to run select query based on combo box selections?
Can anyone help me treating me fresh in Access database
 
A

Al Campagna

Shiva,
Let's say your form is called frmCriteria, and on that form you have one
combo box called cboCity. cboCity will provide the City criteria for a
query.
In your query, the criteria for your City field would be...
Like Forms!frmCriteria!cboCity & "*"

If you select New York, only New York records will be returned.
If you leave cboCity blank, all cities will be returned.

Now, just use that same logic to set up other combos on your form. For
example cboState, or cbo Country, etc... etc...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Top