Print All Records via Report

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

This is the code that should print (all) my checks from a form to a report.
It only prints one record though.
There are no events or code that run from the Report.
How can I make it print all the records?

On Error GoTo Err_Command100_Click

Dim stDocName As String

stDocName = "RCheckAll"
DoCmd.OpenReport stDocName, acNormal

Exit_Command100_Click:
Exit Sub

Err_Command100_Click:
MsgBox Err.Description
Resume Exit_Command100_Click
 
Better check the RecordSource of the Report... I've left in criteria from
separately testing a Query or SQL statement and had the very same thing
happen. Or, perhaps you manually applied a Filter to the Report when you
last executed it.

Larry Linson
Microsoft Access MVP
 
Back
Top