If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Select records from 6 combo boxes
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 |
#2
|
|||
|
|||
Select records from 6 combo boxes
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." "Shiva" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|