(Solved) – INSERT INTO statement not working error 3134

  • by
(solved)-–-insert-into-statement-not-working-error-3134

Currently trying to get my add button to work. I’m trying to insert into a table and I’m getting a Run-Time error ‘3134. I’ve watched several youtube videos and searched here. Not sure why its erroring out. There are no prime keys associated with this table.

CurrentDb.Execute "INSERT INTO tblMemberRecords (strLastName, strTimeType, strCrewPosition, strStartTime, strStopTime, ) " & _
    " VALUES ('" & Me.cboLastName & "','" & Me.cboTimeType & "','" & Me.strCrewPosition & "','" & Me.strStartTime & "','" & Me.strStopTime & "')"

Leave a Reply

Your email address will not be published. Required fields are marked *