I'm using Access 2010 & I'm trying to update a table "Permanent" with details from the current record in a sub form. but I am getting an error message ... Compile error:method or data member not found & it highlights me.contact_fax despite the fact that I chose the field from the pop up field box you get when you're writing the code.
if I remove that particular piece in the update statement then it merely selects another piece to bring up as an error.
The code I am using is below, can anybody help?
Private Sub AddAsInvoicecontact_Click()
CurrentProject.Connection.Execute "UPDATE [Permanent] SET [Permanent].[ Invoice Contact Name] ='" & Me.contact_name & "', [Invoice Contact Title]='" & Me.contact_jobtitle & "', [Invoice Contact Email]='" & Me.contact_fax & "', [Invoice Contact DL]='" & Me.Mobile_Phone & "', [Invoice Contact Switchboard]='" & Me.contact_switchboard & "', [Invoice Contact Address]'" & Me.contact_address & "' WHERE [Permanent].[assignments_guid] = Me.assignments_guid"