Set criteria dependent on check boxes.

[prancer]

I am new to access and VBA. I would like to use a form to get multiple criteria.
FIrstly can I do this from a list? How do you put more than one criteria into a query
Secondly if I want to use check boxes how do I get my check box to apply to my criteria.
EG I am looking at orientation. If they want all buildings that are orientated north and south. THey North and South check box are true. HOw do you assign so the criteria can if chkNorth is true, then criteria is north.

Thanks

[liimra]

Please note that "Check Box" number language is:
Yes/Checked = -1
No/Unchecked = 0

So this is the criteria

IIF([chkNorth]=-1,"North","South")

Of course the expression is very flexible to meet your needs.

To use multiple criteria in your query, simply use "AND" to seperate criteria; for example:

[chkNorth]=-1 And [chkSouth]=0

Regards,
Ali

[prancer]

Thanks that's a great help.

[liimra]

Glad it worked for you. Would you kindly mark this post as answered
so it becomes more helpful for others.

Regards,
Ali