OpenForm "Where condition" contains hyphen (1 Viewer)

[5hadow]

I'm having issues figuring out how to fix this bit of code:

Private Sub fldSerial_Click()
DoCmd.OpenForm "frmDocRevDetail", , , "[fldSerial]=" & MaxOffldSerial
End Sub


MaxOffldSerial contains a hyphen. It looks something like this: DR-22-001.
When I click on the field, it opens the following box:

How do I write the code so that it knows what to open. It seams it stops at hyphen because it's a special character?

 

[CJ_London]

If it has a hyphen then it is text so you need to surround with single quotes. At the moment it is treating you code as a calculation

 

[5hadow]

Never mind, figured it out. It's supposed to be:


Private Sub fldSerial_Click()
DoCmd.OpenForm "frmDocRevDetail", , , "[fldSerial]='" & (Me.MaxOffldSerial) & "'"
End Sub