G
Guest
Hello - I am trying to present two alternatives to a client regardng an
application that she's requested. One alternative is to preview results on a
report that she can also print and the other is to provide screen viewing
only (via forms). She'll be informed that printing from a form will not
yield very good formatting results. The screen viewing provides more of a
performance indicator dashboard tool for the executives of the company who
don't want to be bogged down with a bunch of paper reports. The screen
version of the application will have more navigational features built into it
than the report driven version will.
Nevertheless, here is the code behind a text box serving as the control
source that's placed in the report header. This code works perfectly...
=(Count(IIf([AcceptMonth]=Forms!frmPeriod!Month And
[AcceptDateFY]=Forms!frmPeriod!FiscalYear,1,Null)))
However, when I insert the same code in a text box used as a control source
in a form header, #Err is returned. Rather than inserting the control in the
report header, I've also tried inserting it in a pager header as well as the
detail section and the same #Err result is returned. I've also checked to
make sure that I don't have any redundancies in the naming of any other
controls on the form.
I can't figure out why this works on a report, but not on a form. I'd
appreciate any help that anyone can provide. Thanks.
application that she's requested. One alternative is to preview results on a
report that she can also print and the other is to provide screen viewing
only (via forms). She'll be informed that printing from a form will not
yield very good formatting results. The screen viewing provides more of a
performance indicator dashboard tool for the executives of the company who
don't want to be bogged down with a bunch of paper reports. The screen
version of the application will have more navigational features built into it
than the report driven version will.
Nevertheless, here is the code behind a text box serving as the control
source that's placed in the report header. This code works perfectly...
=(Count(IIf([AcceptMonth]=Forms!frmPeriod!Month And
[AcceptDateFY]=Forms!frmPeriod!FiscalYear,1,Null)))
However, when I insert the same code in a text box used as a control source
in a form header, #Err is returned. Rather than inserting the control in the
report header, I've also tried inserting it in a pager header as well as the
detail section and the same #Err result is returned. I've also checked to
make sure that I don't have any redundancies in the naming of any other
controls on the form.
I can't figure out why this works on a report, but not on a form. I'd
appreciate any help that anyone can provide. Thanks.