IIF statement

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

 

[Jeff Boyce]

Desmond

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