ADO FIND - trouble using strings that contain " ' "

[KirkJewell]

This seems like a basic problem to me - I don't understand why I haven't come across it before.

Using ADO.find = "StaffName = '" & string & "'"
works fine for a string that doesn't have an "'" in it.

But the StaffName column include names like "John O'Carrol" and the additional "'" causes an error.

Can anyone suggest a way around this.

Regards
Kirk

 

[Antzz]

Wherever you have a quote like ', use two single quotes ''