Can someone please tell me what is wrong with this?
IIF(Me.SSN Is Null, (DoCmd.OpenReport "Report1" ,,,), (DoCmd.OpenForm "frmStudentsPaymentLedger2", acNormal))
Thanks,
Al
Can someone please tell me what is wrong with this?
IIF(Me.SSN Is Null, (DoCmd.OpenReport "Report1" ,,,), (DoCmd.OpenForm "frmStudentsPaymentLedger2", acNormal))
Thanks,
Al
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