Query Syntax with Characters 1

[jt463]

I have the following Select statement:

stSelection = Me.Selection.Value

stSQLWhere = "Subdivision = '" & Me.Subdivision.Value & "' AND Selection = '" & stSelection & "'"

This corrects the issue I had when my Me.Selection.Value was:

Add 10"x50" Double-Hung Windows

However, now I have an issue with the following:

9' Foundation Poor

I solved the 9' issue by changing my select to:

Set SelNotesRst = SelNotesDb.OpenRecordset("select * from COSelTotalNotes WHERE Subdivision = '" & Me.Subdivision.Value & "' AND Selection = "" & stSelection & """)

But that presents a problem when my value includes quotes.

Any help would be greatly appreciated. Thank you.

 

[PHV]

ac2k or above:[tt]
stSelection = Replace(Me!Selection.Value, "'", "''")
stSQLWhere = "Subdivision='" & Me.Subdivision.Value & "' AND Selection='" & stSelection & "'"[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jt463]

That worked like a charm! Thank you PH.