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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NESTED IIF STATEMENT. PLEASE HELP. 5
Coding for IIf Statement 3
iff, then, else textbox help!!! revisited... 6
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
IIf question 7
Total in Continous Form 4
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
Access Query problem 1

Back
Top