IIf Statement

[Guest]

I want to have the statement

IIf([BE]>0,[E]*[BE],0)

for the OnEnter property but it doesn't seem to be working. How can I fix
this?

 

[Douglas J. Steele]

"doesn't seem to be working" doesn't tell us much...

You can't put an expression like that as an Event (which is what the OnEnter
property is). You either set the property to [Event Procedure], then put
that code into the module that gets created for you when you hit on the
ellipses (...) to the right of the property, or you need to put it in a
macro.

Either way, IIf([BE]>0,[E]*[BE],0) is pretty meaningless. What are [BE] and
[E]? What do you want done with the results of that IIf statement?