Report Footer Error on Page 2+ but shows on first page

[Liv]

there is a form created to open this report. the query the report depends on,
calls on the value in the combo box. I have included this field in the report
header (which works fine), and the footer (which is kind of funky). the
footer shows correctly on the first page, but after the first page it shows
#error?. Why is this?

footer: =[Forms]![Staff Form]![cboStaffName] & "'s Report"

returns: Alana's Report

page 1 shows as it should, while all pages after show error.

 

[Duane Hookom]

Do you have any code or macro that closes the form?

 

[Liv]

leaving the form open works great! why would my query only work on one page?

Do you have any code or macro that closes the form?

--
Duane Hookom
Microsoft Access MVP

there is a form created to open this report. the query the report depends on,
calls on the value in the combo box. I have included this field in the report
header (which works fine), and the footer (which is kind of funky). the
footer shows correctly on the first page, but after the first page it shows
#error?. Why is this?

footer: =[Forms]![Staff Form]![cboStaffName] & "'s Report"

returns: Alana's Report

page 1 shows as it should, while all pages after show error.

 

[Duane Hookom]

The first page may have rendered prior to the form closing.
--
Duane Hookom
Microsoft Access MVP

leaving the form open works great! why would my query only work on one page?

Do you have any code or macro that closes the form?

--
Duane Hookom
Microsoft Access MVP

there is a form created to open this report. the query the report depends on,
calls on the value in the combo box. I have included this field in the report
header (which works fine), and the footer (which is kind of funky). the
footer shows correctly on the first page, but after the first page it shows
#error?. Why is this?

footer: =[Forms]![Staff Form]![cboStaffName] & "'s Report"

returns: Alana's Report

page 1 shows as it should, while all pages after show error.