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

  • Thread starter Thread starter Liv
  • Start date Start date
L

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.
 
leaving the form open works great! why would my query only work on one page?

Duane Hookom said:
Do you have any code or macro that closes the form?

--
Duane Hookom
Microsoft Access MVP


Liv said:
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.
Click to expand...
Click to expand...
 
The first page may have rendered prior to the form closing.
--
Duane Hookom
Microsoft Access MVP


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

Duane Hookom said:
Do you have any code or macro that closes the form?

--
Duane Hookom
Microsoft Access MVP


Liv said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top