Printing - Viewing

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!
 
Does this report have code, control sources, macros, record sources, section
names, or anything else you would care to share?
 
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!
 
Don't close the form until after the report closes. You can set the form to
invisible.

--
Duane Hookom
MS Access MVP


Amour said:
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 said:
Does this report have code, control sources, macros, record sources,
section
names, or anything else you would care to share?
Click to expand...
Click to expand...
 
Back
Top