Good Afternoon all.
I have the below code and am getting a Compile Error but the spelling is correct and the field exists and is named correctly.
Code:
Private Sub cmdAdd_Click()
'add data to table
CurrentDb.Exceute "INSERT INTO Call Table(reportnumber, vin, code, agentname, comments) " & _
" VALUES(" & Me.txtreportnumber & "','" & Me.txtvin & " ','" & _
Me.cbocode & "','" & Me.txtagentname & " ','" & Me.txtcomm & "')"
'refresh data in list on form
frmCallTable.Form.Requery
End Sub
I am getting the error on 'Me.txtcomm'
Any help would be great.
Many Thanks!