Code for string=string

[millrat]

Previously my code to preview a report was
DoCmd.OpenReport "Report Sheet", acViewPreview, , "Sheet.[Sheet No] = " & Me.txtSheetNo
This worked fine while Sheet.[Sheet No]=1 and Me.txtSheetNo=1 (both integer)
I have since changed the integers to text string ie Sheet.[Sheet No]=01CR01 and Me.txtSheetNo=01CR01
What do I need to add to make this work?
Thanks for your help
millrat

 

[lupins46]

"Sheet.[Sheet No] = '" & Me.txtSheetNo & "'"

 

[millrat]

Thank you very BIG
millrat