I have this code attached to my Print Report command button;
Dim strDocName As String
Dim strWhere As String
strDocName = "NCR Internal"
strWhere = "[NCRNumber]=" & Me!NCRNumber
DoCmd.OpenReport strDocName, acPreview, , strWhere
When I print it, using a full copy of Access, it prints out only the current report. When other users, using Run time access, it prints out all records in the table.
Does anyone see/know why this would do that?
I'm using MS Access 2010.
Thanks for your help!