When the record I want to return contains a # in the criteria the recordset returns no records
for instance cFind = "Jones Store #1" or
cAddr = "6151 Freeport Blvd. #180"

SQL$ = "select [Company], [Address1], [Address2], [City State Zip] from [ShipTo] where [Company] like '" & cFind & "' and Address1 like '" & cAddr & "'"
Data3.RecordSource = SQL$

Any ideas on how to get it to recognize and return the records will be much appreciated.
Thanks!