Compile Error: Method or data member not found

subtilty

Registered User.
Local time
Today, 08:37
Joined
May 18, 2010
Messages
10
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:
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:
Spelling error in CurrentDb.Execute ... ("Exceute") - correct that and it should work
 
Thanks NickHa...

What a stupid mistake :)
 

Users who are viewing this thread

Back
Top Bottom