how to use IIF()

R

Roadwarrior1

I am trying to do a condition where if an address is enter and it is the same
then it will put the value same as above if it is not then it will take the
value inputted.
Here is my expression:

=IIf([POB STREET].AfterUpdate=[HOR STREET].AfterUpdate,"SAME AS ABOVE")
 
B

bhicks11 via AccessMonster.com

Is After Update the name of the control or an event?

Bonnie
http://www.dataplus-svc.com
I am trying to do a condition where if an address is enter and it is the same
then it will put the value same as above if it is not then it will take the
value inputted.
Here is my expression:

=IIf([POB STREET].AfterUpdate=[HOR STREET].AfterUpdate,"SAME AS ABOVE")
Click to expand...
 
Top