See Code Below, Need to Print out ALL Records, How???

[Dave Elliott]

On Error GoTo Err_Command75_Click
'Forms!FEmpTotHours.Visible = False
DoCmd.OpenReport "RCheckAll", acNormal, "",
"[EmployeeID]=[Forms]![FEmpTotHours]![EmployeeID]"

Exit_Command75_Click:
Exit Sub

Err_Command75_Click:
MsgBox Err.Description
Resume Exit_Command75_Click

--


---------------------------------------------------------------------
This email and any files transmitted with it from Dave Elliott are
confidential and intended solely for the
use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the
sender.
All Mail is pre-scanned with Norton Antivirus 2004 for your protection.

http://[email protected]

 

[George Nicholson]

You are telling Access to open the report using
"[EmployeeID]=[Forms]![FEmpTotHours]![EmployeeID]" as a filter. That is, to
show only the records where EmployeeID equals the value of the specified
field on the specified form.

If you want the report to include all EmployeeIDs, remove that clause:
DoCmd.OpenReport "RCheckAll", acNormal

Hope this helps,