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

  • Thread starter Thread starter Chris Emery
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top