OpenForm "Where condition" contains hyphen

5hadow · Jan 31, 2022

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 · Jan 31, 2022

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 · Jan 31, 2022

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


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