Combo boxes and criteria.

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

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.
 
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]
Click to expand...
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

C K said:
Hello
My database has 2000 to 3000 records. My staff does not know how to use
Click to expand...
queries and expressions to filter it.
How could I create one simple form with 2 combo boxes, each with a list of
Click to expand...
criteria to choose from, in order to filter one field in one table?
 
Thank you Nikos, we'll try to make it work.
C K

Nikos Yannacopoulos said:
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]
Click to expand...
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

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