The following statement bombs when the StoreName value has an apostrophe in it. How can I modify this statement to accept these values?
I always get turned around on these darn characters.Code:If DCount("StoreName", "Stores", "StoreName = '" & Me.txtStoreName.Value & "'") > 0 Then
Thank you in advance
Access 2010