Multiple Conditions

C

Cory

I am trying to populate a field on a form if certain conditions are met such
as:

If checkbox1 is true then display x
If checkbox 2 is true then display y
If both are true then display z
If both are false then display w

Any help will be greatly appreciated!
 
A

Allen Browne

Use Switch(), Choose() or nested IIf() expressions.

See the help in Access for details an examples.

If you actually have lots more checkboxes than the 2 in your example, you
might get better results by redesigning the table:
http://allenbrowne.com/casu-23.html
 
C

Cory

The nested Iif() works just fine but it is a little dirty and confusing.
Thanks for your help.
 
Top