Drop down list in a query

[mogul0212]

Hello,

Ok, let me preface this with I'm a newbie at Access, and I'm currently using Access 2003. I'm just hoping someone can point me in the right direction. Right now I have multiple tables with set data in them that doesn't change linked to another table where I have a drop down menu (combo box I think it's called in Access) to easily select the given data from. I want to have a drop down box (combo box) to have a set of given variables I have in a table to put in the search criteria. That way a user doesn't have to type the exact criteria into a query. That way I can easily put in the variables I want to search from in the query with less chance of an error. I'm hoping this is possible.

Ideally if I could get help in how to make a form that would allow me to have the set of columns from the corresponding tables with combo boxes to select from and then be able to have a "subimt" button and have it organize the selected results into that form as well.

Thank you for taking time to read this.

 

[John Big Booty]

Make yourself a new form and put the Combo boxes you wish to use as the criteria in your search. Make sure that the field you wish to search on is one of the fields in the Combo Box, eg. if you wish to search on the ClientID for example, it should be "Value” that the combo box "Remembers for later use.

Once you have set up your form write your query, using the criteria [Forms]![FRM_Name]![Combo#] for each of the combo boxes.

Now you can put a button on your search form that opens another form to display the data from your query.

 

[mogul0212]

thx John Big Booty,

I've got that part created and works well.