Printing - Viewing

[Guest]

When I print directly (acviewNormal) their is no problem.

But when I use the acviewPreview option the the first page comes out right,
but following pages comes out with #Name? on the view option only.
When I print the report using acviewPreview some of the options are blank,
even the display of the correct first page.

Example1: Printing directly
A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

A= Tech
B= Science
C= Accounting And so on:

Example2: When viewing

A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

A= #Name?
B= #Name? And so on:

any idea's, please help,
Thank You!!

 

[Duane Hookom]

Does this report have code, control sources, macros, record sources, section
names, or anything else you would care to share?

 

[Guest]

I have no code on the report. The record source is a query, but is not
linked to the textbox in question. The way I get the information needed for
the textbox(s) is:
=[Forms]![frmExperienceFilter]![frmPersExperience]![Combo2]

Where Combo2 information comes from the user selecting from a drop down
within the Combobox(s) and clicking on the print button.

I close the form that holds the combobox(s) after opening the report:

DoCmd.OpenReport Reportname, acViewPreview
DoCmd.Close acForm, "frmExperienceFilter"


Thank You for any help!

 

[Duane Hookom]

Don't close the form until after the report closes. You can set the form to
invisible.

--
Duane Hookom
MS Access MVP

I have no code on the report. The record source is a query, but is not
linked to the textbox in question. The way I get the information needed
for
the textbox(s) is:
=[Forms]![frmExperienceFilter]![frmPersExperience]![Combo2]

Where Combo2 information comes from the user selecting from a drop down
within the Combobox(s) and clicking on the print button.

I close the form that holds the combobox(s) after opening the report:

DoCmd.OpenReport Reportname, acViewPreview
DoCmd.Close acForm, "frmExperienceFilter"


Thank You for any help!

Does this report have code, control sources, macros, record sources,
section
names, or anything else you would care to share?