Dear all
Please help me fix error message below:
I have a textbox: Data Source (Text type)
When I enter: David's contacts and click update button, it have problem with error below:
Run-time error '3075' Syntax error (missing operator) in query expression "David's" WHERE ID =1'.
at line code:
CurrentDb.Execute " UPDATE tblContacts SET [Data Source] = '" & Me.Data_Source & "' WHERE ID = " & Me.ID
If enter Davids contact (not ' ) it's fine
Please let me advices
Many thanks