How to define variable witin SQL statement 1

[DanKay1]

CurrentDb.OpenRecordset("SELECT CompanyList.CompanyCode, CompanyList.REINSURER FROM CompanyList Where Reinsurer = '" & cmbReinsurerName & "'")

cmbReinsurerName = "Loyd's"

and it Kicks me out is there a way to define the variable within sql statement so it would give an error.
it works for all other inputs except for ' - single quatation mark.

Thank you.

 

[PHV]

If ac2k or above, replace this:
Where Reinsurer = '" & cmbReinsurerName & "'")
By this:
Where Reinsurer = '" & Replace(cmbReinsurerName, "'", "''") & "'")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244