Syntax for string that contains an apostrophe 1

[theSizz]

Can some one help with the proper syntax for having a form filter a string that contains an apostrophe.
Such as a field with the name O'Toole in it.
Here's what I wrote but it produces an error.

Private Sub Form_Load()

DoCmd.ApplyFilter , "provider = 'O'Toole' or provider2 = 'O'Toole'"

End Sub

I realize it's the apostrophe in O'Toole that is causing the problem. I just don't know how to write the proper syntax.
Can some one help?

Thanks for the help.

 

[Golom]

Private Sub Form_Load()

DoCmd.ApplyFilter , "provider = 'O''Toole' or provider2 = 'O''Toole'"

End Sub

 

[theSizz]

Thanks for the quick reply Golom.
That did the trick.