Report heading prints as #Name? athough in preview is OK

C

Chris Emery

Hi! I have a report that takes part of the heading data from a value on a
form. It looks OK on the print preview but actually prints only #Name? as
the heading. Why can't it find the data? I am using Access 2002 SP3.

Thanks, Chris.
 
F

fredg

Hi! I have a report that takes part of the heading data from a value on a
form. It looks OK on the print preview but actually prints only #Name? as
the heading. Why can't it find the data? I am using Access 2002 SP3.

Thanks, Chris.
Click to expand...

Somehow between Report Preview and Report Print you have closed the
Form.
Check your code.
 
C

Chris Emery

Fred,

There are no events on the Report and all I do is hit the "Printer" button
on the toolbar while looking at the Preview, however I fixed it by changing
the data source from the [Form]![x].[x] to a DLookup on the source data in
my Globals Table. Probably better programming anyway. I still don't know
what was wrong with using the form?

Thanks, Chris.
 
Top