IIF Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get this to work right. I am stumped.
Example: IIF(Me!.Total =1,Call form 1, DO NOTHING)
 
Mal said:
How can I get this to work right. I am stumped.
Example: IIF(Me!.Total =1,Call form 1, DO NOTHING)
Click to expand...


IIf is a function that returns a value, so it can not be
used this way. OTOH, it looks like you are probably trying
to do this in an event procedure using VBA code.

If so, then you should be using the IF statement:

If Me.Total =1 Then
DoCMD.OpenForm "form 1"
End If
 
Back
Top