How Cope With Apostrophe in Variable?

[Guest]

My VBA command line is

DoCmd.OpenReport strCoverLtr, , , "DonName =" & "'" & strDonorFilter & "'" &
""

It works perfectly until it gets to a donor named O'Neal. At that point
strDonorFilter causes a crash. Is there a trick for this?

Thanks

 

[SirPoonga]

tempFilter= Replace(strDonorFilter, "'". "''")
DoCmd.OpenReport strCoverLtr, , , "DonName =" & "'" & tempFilter& "'" &

""

 

[SirPoonga]

Errr, or simplify to

DoCmd.OpenReport strCoverLtr, , , "DonName =" & "'" &
replace(strDonorFilter, "'", "''") & "'" &
""

 

[Guest]

Thank you! I will give it a try!