iif(Expression) Problem..

[m1kee]

I have two text boxes on a form which need to be able to calculate values, I can run an If statement in VBA and that runs fine; which is:
If Me.OrderOrigin = "Home" Then
Me.IncostHome = Me.TotalPrice * 0.0525 + 0.4
Else
Me.IncostHome = Me.TotalPrice = "£0.00"
End If
but when I try to convert this statement into an IIF expression things go wrong and normally the program just bombs out!

Could someone please tell me the best way to put this into an IIF expression using the expression builder; I need it to be the control source for the text box.

Many thanks,
Mikee.

Do or do not, there is no try. - Yoda

 

[scriverb]

First of all, there must be a typo in the else portion of the above posted example of your IF statement.

Me.IncostHome = Me.TotalPrice = "£0.00" ??????? Makes no sense

The following is the format for the IIF statement

IIF(Me.OrderOrigin = "Home", Me.TotalPrice * .0525 + .4, [red][i] false value/calculation [/i] [/red])

Replace the red code with what you want returned if the expression is false.


Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]