report not linking criteria on print

[belovedcej]

This is odd. The following code works perfectly. But as soon as I change acViewPreview to acViewNormal, the report prints every record instead of just the linked one. Any ideas?

Dim stLinkCriteria As String
stLinkCriteria = "[Phone_Message_ID] = " & Me.txtPhoneMessageID
DoCmd.OpenReport "rptPhoneMessages", acViewPreview, , stLinkCriteria

 

[belovedcej]

I figured it out. instead of txtPhoneMessageID (the name fo the control) I did Phone_Message_ID (the name in the db). That worked.