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


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.
 
Ad

Advertisements

L

Liv

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.
 
Ad

Advertisements

D

Duane Hookom

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.
 

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