Thank You all. The problem was the apostrophe in the sql query. My “shotgun” testing disguised what should have been obvious to me in the first place.
I elected to use a search and replace to sanitize this and similar queries but the PreparedStatement method will be used in the future.
From this:
sql = “Select * From Checklist Where Name =’” + ChecklistItem + “’”
to this:
Dim st As Text =ChecklistItem
st =st. ReplaceAll("’", “’’”)
sql = “Select * From Checklist Where Name =’” + st + “’”
This allowed me to enter O’Brien’s Beer&Wine as a test with impunity.
(Figured I’d check for a possible ampersand error at the same time.)
Occams Razor, Right?