Show Parameter Information in Report Footer

B

Basenji

Using Access 2003 I have a form with text boxes to enter the parameters for a
report. Then I added text boxes with the control source,
=(Forms!frmPatientActivityDateRangeCriteria!StartDate) for the start date and
=(Forms!frmPatientActivityDateRangeCriteria!EndDate) for the end date, to the
report so that the parameter dates appear in the report header. The dates
appear in the report header. Now, I would like for those same dates to appear
in the report footer so that if the last page only of the report (which has a
number of calculated controls counting other records in the report) is
printed it will show the dates for the report. I have tried copying the text
boxes from the report header to the report footer and get a name error. I
have tried a text box that has the control source as the name of the text box
of the date in the report header and get a name error. Any suggestions for
having the parameters in the report footer as well as the report header are
welcome. Thank you.
 
F

fredg

Using Access 2003 I have a form with text boxes to enter the parameters for a
report. Then I added text boxes with the control source,
=(Forms!frmPatientActivityDateRangeCriteria!StartDate) for the start date and
=(Forms!frmPatientActivityDateRangeCriteria!EndDate) for the end date, to the
report so that the parameter dates appear in the report header. The dates
appear in the report header. Now, I would like for those same dates to appear
in the report footer so that if the last page only of the report (which has a
number of calculated controls counting other records in the report) is
printed it will show the dates for the report. I have tried copying the text
boxes from the report header to the report footer and get a name error. I
have tried a text box that has the control source as the name of the text box
of the date in the report header and get a name error. Any suggestions for
having the parameters in the report footer as well as the report header are
welcome. Thank you.

Setting an unbound control, in the report's report footer section to
=forms!FormName!ControlName
works for me and displays the value from the form control in the
report footer.
If you are getting a #Name error in the report footer, I would suspect
that somewhere, between the opening of the report and the display of
the report footer, somehow the form is being closed before the report
is closed. Check all of the code in the report for
DoCmd.Close acForm "frmPatientActivityDateRangeCriteria"
 

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

Top