SOLVED - Compile Error: Method or data member not found
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:
I am getting the error on 'Me.txtcomm'
Any help would be great.
Many Thanks!
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:
Code:
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!
Last edited: