What is causing this error

[mrrayj60]

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 **

 

[wiklendt]

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)