Opening a report

[Guest]

Hello,

Im trying to open a report using a print buton and restrict its records to
the value of a text box on a form. Under a print button I have this code

DoCmd.OpenReport "rpt_SelectMemberRequest", acViewPreview, memberID =
Forms!frm_memberOverrideRequest!txtMemberID

Im getting all the records. I only want the records that match the value in
the text box. Does anyone know how to do this?

 

[Roger Carlson]

You need quote marks in you criteria string:

DoCmd.OpenReport "rpt_SelectMemberRequest", acViewPreview, _
"memberID = " & Forms!frm_memberOverrideRequest!txtMemberID

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L