Text ending in quotes cause syntax error

[NewShortStuff]

I am using the following code to select a record from a combo box, but when I select a record with text that ends or contains quotes I get a syntax error.

DetailTB.Open "Update Detail set [added]='1' Where LineName = """ & Me!LineName & """"

Example: #19 B-6-11 Lateral 8" causes the following error
Syntax error in string query expression 'Line Name = "#19 B-6-11 Lateral 8"'".

 

[mmilan]

You're using both " and ' as string specifiers in your statement. Try using ' in the where clause

 

[Golom]

Your 4 closing quotes are producing two (not just one) double quote at the end. Try this
[blue][tt]
Where LineName = """ & Me!LineName & """
[/tt][/blue]

 

[NewShortStuff]

It worked, thank you so much!

I triend Where LineName = '" & Me!LineName & "'

 

[chiph]

You might want to look at the FAQ in the VB & Databases forum entitled "Single Quotes are causing problems".

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first