Multiple Conditions

  • Thread starter Thread starter Cory
  • Start date Start date
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!
 
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
 
The nested Iif() works just fine but it is a little dirty and confusing.
Thanks for your help.
 
Back
Top