Using multiple checkboxes

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

Guest

Hi
My problem is this; i got Query (qryETime) that is getting date and name
from form (frmETime) date is date range and name is combo, that all work
fine. Once ran it will display annual leave, sick leave, comptime used,
comptime worked...etc. basicaly all the exceptions. What I would like to do
is have checkboxes on frmETime for annual, sick,... once person selects it it
will display only the selected time. They would be free to select multiple
checkboxes or just one. In query i can insert >0 and query will give me let's
say all Annual Leave greated then zero. how do you do it from form ????
Thank you.
 
Further information needed on your table structure. Do you have separate fields
in one table for each type of leave? Or do you have one field to store the
amount and another to identify the type?

Assuming that you have multiple fields and that the fields always contain some
value and that your checkbox has a name like chkAnnual you might try

Field: Annual
Criteria: < IIF(Forms!frmETime!chkAnnual=True,99999999,0)

You would need to stair step the criteria for each type of leave, so SickLeave
would look like

Field: Sick
Criteria: <Blank>
NextCriteriaLine: < IIF(Forms!frmETime!chkSick=True,99999999,0)

If you have a more normalized data structure then post back with the structure
and perhaps we can work out a solution.
 
Back
Top