Printing ALL Records

[Gulf Coast Electric]

I need for this code to print all the records from this form to Report.
Right now it is printing only one at a time.The forms name is
FEmpTotHours. Report name is RCheckAll


On Error GoTo Err_Command75_Click

DoCmd.OpenReport "RCheckAll", acNormal

Exit_Command75_Click:
Exit Sub

Err_Command75_Click:
MsgBox Err.Description
Resume Exit_Command75_Click

 

[Jim Allensworth]

I need for this code to print all the records from this form to Report.
Right now it is printing only one at a time.The forms name is
FEmpTotHours. Report name is RCheckAll


On Error GoTo Err_Command75_Click

DoCmd.OpenReport "RCheckAll", acNormal

Exit_Command75_Click:
Exit Sub

Err_Command75_Click:
MsgBox Err.Description
Resume Exit_Command75_Click

The problem is with the report not the code to open it.

Open the report in preview (while the form is open) and see what you
have.


- Jim

 

[Dan Artuso]

Hi,
As Jim said, the probelm is with your report. If you want it print the same recordset as
your form, make the report's RecordSource the same as your form's.