Basic Syntax Question - Docmd.OpenReport In IIf Statement

[alsoto]

Can someone please tell me what is wrong with this?

IIF(Me.SSN Is Null, (DoCmd.OpenReport "Report1" ,,,), (DoCmd.OpenForm "frmStudentsPaymentLedger2", acNormal))



Thanks,
Al

[hertfordkc]

It says that the true and false portion of the statement are always evaluated, regardless of the true/false test. It also says that both the true and false parts must return a result. Not sure about that for DoCmd.....

[alsoto]

It says that the true and false portion of the statement are always evaluated, regardless of the true/false test. It also says that both the true and false parts must return a result. Not sure about that for DoCmd.....

I believe that is the problem, can't use VBA in an IIF statement.

Thanks