Compile Error: Method or data member not found

[subtilty]

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.

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!

[jzwp11]

You are missing a single quote before me.txtReportnumber and since you have a space in your table name, it must be enclosed in square brackets

CurrentDb.Exceute "INSERT INTO [Call Table] (reportnumber, vin, code, agentname, comments) " & _
" VALUES ('" & Me.txtreportnumber & "','" & Me.txtvin & " ','" & _
Me.cbocode & "','" & Me.txtagentname & " ','" & Me.txtcomm & "')"

[subtilty]

Hi,

I have adjusted the code as per your reply to:

CurrentDb.Exceute "INSERT INTO [Call Table](reportnumber, vin, code, agentname, comments) " & _
" VALUES('" & Me.txtreportnumber & "','" & Me.txtvin & " ','" & _
Me.cbocode & "','" & Me.txtagentname & " ','" & Me.txtcomm & "')"

But the error is still there. Any other idea's? Thanks so much

[jzwp11]

What are the datatypes of each of the 5 fields of the call table?

[subtilty]

It's ok it was my bad... I spelt Execute wrong

[jzwp11]

I missed that too! Glad you got it sorted out.