Hello Daniel,

For your problem, for each textbox, you could use the Replace function to double the single-quotes...

Replace(txtHospital.text, "'", "''")

Hope that helps


In case you don't know about SQL Injection, you might like to read this :
http://msdn.microsoft.com/msdnmag/issues/04/09/SQLInjection/default.aspx




Regards,
Alex