Printing ALL Records

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

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
 
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
Click to expand...
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
 
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.
 
Back
Top