How to refer to field name ending with "# " that is not a date

[capndave]

I mistakenly chose to name a field "MR#" and now in an event procedure this is seen as a date. How do I refer to the field "Forms!CAD_LOG1!MR#" in the statement below

Private Sub PrintHx_Click()
On Error GoTo Err_PrintHx_Click

Dim stDocName As String

stDocName = "rptPatientHx"
DoCmd.OpenReport stDocName, acPreview, , "[MR#]=Forms!CAD_LOG1!MR#"


Exit_PrintHx_Click:
Exit Sub

Err_PrintHx_Click:
MsgBox Err.Description
Resume Exit_PrintHx_Click
End Sub


Thanks

 

[AlexCuse]

Put it in square brackets [ ]

A wise man once said
"The only thing normal about database guys is their tables".

 

[AlexCuse]

Just around the MR# part

Hope this helps,

Alex

A wise man once said
"The only thing normal about database guys is their tables".