I have a listbox that reads values from a query. At least one item it returns contains double quotes. I cannot be sure that others won't contain single quotes. And there is also the possibility a record might contain both.
my code is:
Is there another way of writting this such that single or double quotes will not cause it to fail?Code:rs.FindFirst "[Name] = " & Chr(34) & Me! [List_AssignedStaff] & Chr(34)