Report does not print as shown in print preview

[CMontoro]

In a report, in the header there is a control defined by the formul :

"From date: " & Forms!Sales!Begin & " - To date: " & Forms!Sales!End

In the print preview the data is showing up correctly, but when you go to print the report it is printing #name?

Any suggestions would be very much appreciated.
Thanks in advance

Carlos.

 

[pbaldy]

The form would have to still be open; is it?

 

[CMontoro]

Hi Paul
Yes. the form was opened
Thanks

 

[faisal733]

Hi there,
Can you help me about an access program please? My problem is printing a report. my VBA coding is for printing a single report as follows:

Private Sub cmdPrint_Click()
Dim stDocName As String
stDocName = "Customer Detail"
DoCmd.OpenReport stDocName, acViewNormal, , "[Reference_No]=" & Me!Reference_No
End Sub

When I click at the "Print Report" button, It prints the specific records of report successfully, but before printing the specific records (if the record is in the 5th page), it prints previous blank pages (i.e. 4 blank pages) first which is really annoying. Do you understand my problem what I wanted to mean and say? Is there any way to solve this problem and just to print the particular record of specific page (even there are 1000 pages in the database) of report, not printing with blank pages? If you solve my problem, I would really be grateful to you for ever. Many thanks.

I'm looking forward to hear from you soon.

Yours Sincerely

Faisal Salahuddin

 

[Rich]

Your margins are too wide