J
Jeff G
All -
I have a form with a combo box. The query for selecting the items for the
combo box is where my question is. I'd like to have a different set of
criteria based on a field on the form.
Table where the values for the query are pulling from (tblActivityType):
ActivityID ActivityIC ActivityEC ActivityNorm
AB -1 0 0
AUD -1 0 0
ECS1 0 -1 0
HARD -1 -1 -1
MON 0 0 -1
....
On the form there is 2 checkboxes, IC and EC. There can be a check in
either one of those boxes or none at all. The combo box would display the
entries of tblActvityType for ActivityIC if the IC box was checked. If the
EC box was checked, it would show the entries in tblActvityType for
ActivityIC. If neither box was checked, it should show the entries for
ActivityNorm.
Both checkboxes cannot be checked at the same time...only IC can be checked
or EC or none at all.
How would I construct the Query criteria to accomplish this???
Any help would be much appreciated.
Thanks.
Jeff
I have a form with a combo box. The query for selecting the items for the
combo box is where my question is. I'd like to have a different set of
criteria based on a field on the form.
Table where the values for the query are pulling from (tblActivityType):
ActivityID ActivityIC ActivityEC ActivityNorm
AB -1 0 0
AUD -1 0 0
ECS1 0 -1 0
HARD -1 -1 -1
MON 0 0 -1
....
On the form there is 2 checkboxes, IC and EC. There can be a check in
either one of those boxes or none at all. The combo box would display the
entries of tblActvityType for ActivityIC if the IC box was checked. If the
EC box was checked, it would show the entries in tblActvityType for
ActivityIC. If neither box was checked, it should show the entries for
ActivityNorm.
Both checkboxes cannot be checked at the same time...only IC can be checked
or EC or none at all.
How would I construct the Query criteria to accomplish this???
Any help would be much appreciated.
Thanks.
Jeff