Print out single record onto a report

[CQCDave]

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!

[ranman256]

Wow , that's odd. Test this,
right before the line: DoCmd.OpenReport
put: msgbox Me!NCRNumber
then run it in the runtime and see if it pops with the correct ID?

Its POSSIBLE that if no ID is present, it may print all.

[CQCDave]

Well, that worked, displays the record number in a message box and once that is clicked away it goes to the print preview. Thanks for your help. That was weird!