Anybody know how to create criteria that will allow a dropdown list of options to limit the query?
J Jan Oct 22, 2007 #1 Anybody know how to create criteria that will allow a dropdown list of options to limit the query?
O Ofer Cohen Oct 22, 2007 #2 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]
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]
