This has to be an easy question

[dragonsbb16]

i have a access application that does a simple filter

here is my code..

dim filter as a sting

filter = "CenterName = '" & NameSel.Value & "'"

DoCmd.OpenForm FormName
DoCmd.ApplyFilter , filter
DoCmd.close acForm, FormName2

This function works fine UNTIL
NameSel.Value = "Adult's"

And the reason is b/c there is a single quote in the value...what is the best way to solve this? Any help would be great. thanks.

 

[WayneRyan]

dragon,

filter = "CenterName = """ & NameSel.Value & """

Wayne

 

[Sergeant]

You need a 5hit load of double quotes: (extra spaces added for clarity)

filter = "CenterName = " " " & NameSel.Value & " " " "

I just realized that Wayne Ryan already answered this question on one of your (triplicate) posts.

 

[WayneRyan]

I just realized that sergeant added a much-needed double-quote at
the end of my example.

Thanks Sarge,
Wayne