Help me Error: Compile error: Method or data member not found when create Update button
Help me Error: Compile error: Method or data member not found when create Update button
It would help if we could see all the code.
Is there a field called 'Mobile' on your Form [I'm assuming the 'Me' refers to a Form].
Yes, I have Mobile field in Form tblContacts
My Code:
Private Sub cmdUpdate_Click()
CurrentDb.Execute " UPDATE tblContacs SET Mobile = '" & Me.Mobile & "' WHERE ID = " & Me.RecordID
DoCmd.Close acForm, Me.Name
End Sub
Sorry, It's tblContacts, I edited, but the same, pleasee image below
I have a Title field in tblContacts
Sometimes Access can get a little funky. Try a decompile before going further, see if that doesn't resolve the problem: http://stackoverflow.com/questions/3...-and-recompile.
It's not supposed to matter, but try changing Me.title to me!Title. At least then the compiler won't try to find a method called .Title. I had that happen just the oper day.
John
can't to apply in my question
Thanks,