Microsoft Access 2003 Help! Queries using Forms?

How do you created forms that does queries?

for example, I would like to have a form that contains combo boxes (ie. drop down bars) of various criteria, such that when a user selects the various criteria that he wants (say, age between _ and _, Male), and clicks ''Go'', the results fitting all the criteria are displayed just like in a query.

I do not have visual basic coding experience, and create most of my forms using the wizard.

I'm using Microsoft Access 2003. I already have the ERD and various tables filled in.

Please Help! Thanks.

Microsoft Access 2003 Help! Queries using Forms?hp

Create a form like usual - using the wizard is easiest.

When you're done open the form in design view. Select combo box from the toolbox. Draw one on the form.

The combo box wizard will pop-up. Choose the 3rd radio button, ''Find a record on my form based on the value I select in the combo box'' and click next. Choose the field you want to be able to select from, click next and then click finish.

You're done! :)

Hint: you can add more than one combo box. So say you have a database of contacts. First you can pick State and only get records for the selected state. And then pick City and you'll get the records for that city chosen out of the results for the previously choosen state.