IIF statement

  • Thread starter Thread starter Desmond
  • Start date Start date
D

Desmond

I have created the following iff statement to key off of
a text box on a separate form, but it is not working,
what am I doing wrong?

=IIf([Forms]![Query Control Form]![STATE]
="AB","Alabama","Other Region")

I am being told that the expression I entered may contain
invalid syntax. Can you help me?
 
Desmond

Nothing jumped out at me. What happens if you rename the form and control,
and rebuild the query? Sometimes Access gets "confused"...
 
Back
Top