Criteria within queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anybody know how to create criteria that will allow a dropdown list of
options to limit the query?
 
Create a form with a drop down (combo box) and then run the query that will
have a reference to this combo

Select * From TableName
Where FieldName = Forms![FormName]![ComboName]
 
You must log in or register to reply here.

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

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Access Dcount (multiple criteria) 3
Help With MS Access 4
Limitation on ORs in Query 3
criteria on form 1
All-Record criteria in a query...hmmm 4
Numerical query criteria and quotation marks 1
Building Complex Criteria for Queries in Access 2007 1

Back
Top