Multiple Conditions

[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!

 

[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

 

[Cory]

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