Combo boxes and criteria.

[Guest]

Hello
My database has 2000 to 3000 records. My staff does not know how to use queries and expressions to filter it.
How could I create one simple form with 2 combo boxes, each with a list of criteria to choose from, in order to filter one field in one table?
Thanks for your help.

 

[Nikos Yannacopoulos]

Make a form called, say, frmCriteria, and put the two combo boxes on them,
valled, say, cbo1 and cbo2.
Make a query on the table, and in the crireria line(s) use references to the
combos like:
Forms![frmCriteria]![cbo1]
or

= Forms![frmCriteria]![cbo1] AND =< Forms![frmCriteria]![cbo2]

etc. according to your needs. As long as the form is open, the query will
read the criteria from it. Ideally, you would use a command button on the
same form to open the query, or make a form on the query and open the form
from the command button, so the users work on a form rather than in a
datasheet.

HTH,
Nikos

Hello
My database has 2000 to 3000 records. My staff does not know how to use

queries and expressions to filter it.

How could I create one simple form with 2 combo boxes, each with a list of

criteria to choose from, in order to filter one field in one table?

 

[Guest]

Thank you Nikos, we'll try to make it work.
C K

Make a form called, say, frmCriteria, and put the two combo boxes on them,
valled, say, cbo1 and cbo2.
Make a query on the table, and in the crireria line(s) use references to the
combos like:
Forms![frmCriteria]![cbo1]
or

= Forms![frmCriteria]![cbo1] AND =< Forms![frmCriteria]![cbo2]

etc. according to your needs. As long as the form is open, the query will
read the criteria from it. Ideally, you would use a command button on the
same form to open the query, or make a form on the query and open the form
from the command button, so the users work on a form rather than in a
datasheet.

HTH,
Nikos

Hello
My database has 2000 to 3000 records. My staff does not know how to use

queries and expressions to filter it.

How could I create one simple form with 2 combo boxes, each with a list of

criteria to choose from, in order to filter one field in one table?

Thanks for your help.