Prev: Library Checkout 911
Next: Reports Layout Not Working
From: Liv on 30 Nov 2009 17:52
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.
From: Duane Hookom on 30 Nov 2009 22:08
Do you have any code or macro that closes the form?

--
Duane Hookom
Microsoft Access MVP


"Liv" wrote:

> 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.
From: Liv on 1 Dec 2009 12:30
leaving the form open works great! why would my query only work on one page?

"Duane Hookom" wrote:

> Do you have any code or macro that closes the form?
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Liv" wrote:
>
> > 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.
From: Duane Hookom on 1 Dec 2009 18:00
The first page may have rendered prior to the form closing.
--
Duane Hookom
Microsoft Access MVP


"Liv" wrote:

> leaving the form open works great! why would my query only work on one page?
>
> "Duane Hookom" wrote:
>
> > Do you have any code or macro that closes the form?
> >
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "Liv" wrote:
> >
> > > 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.
 | 
Pages: 1
Prev: Library Checkout 911
Next: Reports Layout Not Working