I've tried to go the insert method but get an error expected: end of statement. I'm just trying a few simply fields before I work on dates and cash. It highlights the word(table) vrcfines . Its in a command button, click. 2003access

INSERT INTO vrcfines ([ubl][name])
VALUES (vrcedit!txtubl), (vrcedit!txtname)


** problem resolved **

i use this code:


'Append the selected entry to the associated table
CurrentDb.Execute "INSERT INTO tblMassageData_AssObservations (MassageID, ObservationID) " & _
"VALUES (" & Me.txtMassageID & ", " & selection & ")"


maybe try to prefix your code with CurrentDb.Execute ? (don't forget the quotation marks)