Combo Box Criteria Question

[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

 

[Jeff Boyce]

Already answered in another newsgroup. It's rarely necessary to post the
same question to different newsgroups. Doing so makes you work harder to
check them all to see if your question was answered, and it makes us work
harder, since Person2 has no way to know that Person1 already answered the
question!

Regards

Jeff Boyce
Microsoft Office/Access MVP