If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Footer Error on Page 2+ but shows on first page
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. |
#2
|
|||
|
|||
Report Footer Error on Page 2+ but shows on first page
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. |
#3
|
|||
|
|||
Report Footer Error on Page 2+ but shows on first page
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. |
#4
|
|||
|
|||
Report Footer Error on Page 2+ but shows on first page
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. |
#5
|
|||
|
|||
Report Footer Error on Page 2+ but shows on first page
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. |
#6
|
|||
|
|||
Report Footer Error on Page 2+ but shows on first page
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. |
#7
|
|||
|
|||
Report Footer Error on Page 2+ but shows on first page
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. |
#8
|
|||
|
|||
Report Footer Error on Page 2+ but shows on first page
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. |
Thread Tools | |
Display Modes | |
|
|