Hello,
I've been using access for many, many years, but I've run into a problem with subreports. The issue is that my IIF statement works intermittently. The first screen shot is of the report working. After saving the report, closing the DB, then re-opening, the #Name? error comes back (2nd screen shot below).
"Budget Projection" and "Payroll and Fringe Estimate Through Budget End Date" are both subreports on a report named "Budget Status." These reports pull criteria from a form [frmReportMenu]. I'm pulling [txtPayrollEstimate] from the report footer of the second sbrpt and using it in a calculation on sbrpt "Budget Projection."
BUT, in order to troubleshoot the cause of #Name? error, I simplified my IIF statement to: =IIf([Account]="SAL_SP",1,0)
This simplified IIF is producing the same error. So, IIF is intermittently not recognizing [Account] (second column below). I used the expression builder and it has no problem with [Account] and I have no duplicates of Account either. Account is the text box name and the control source from the query that feeds the sbrpt "Budget Projection."
I'm sure there are multiples ways to do what I'm doing, but my VBA skills are very limited. In other works, I avoid it at all costs.
Thank you in advance for any help.
ByronC
After saving, closing and re-opening, the error returns (when I took this screen shot the Account label was "Category" but I changed it back to "Account" for this post.