String problem. simple 4 u but

[Radhesham]

Dear all

strSQL = "associate_name = '" & Text2.Text & "'"
rst.find strSQL

gives an error bcoz Text2.text contain

JOHN'S CLINIC

It contains an apostrophy.
How to deal with this.
urgent pls
thanx