Method or Data Member not found

[JohnnyBQue]

Sorry guys but My syntax identification and usage is weak...just getting back into writing code...I've used this code below a number of time in other forms...just changed the field names etc...but this time I can seem to SEE what I've done wrong here...my eyes are starting to hurt...to me it's acting like it can't find a module. I think it's some where between " VALUES and Me.cboHmCellWk2 & "')"

 

[JohnnyBQue]

OK found that I missed spelled Execute corrected the spelling now I get this...

Run-time error '3134':

Syntax error in INSERT INTO statement.

I'll keep looking I'll eventually find it....

 

[JHB]

Text values should be surrounded with ', numbers not!
Compare the "Insert Into" and the "Update" and you'll see the differs.

 

[JohnnyBQue]

Thanks guys for all your help but I figured it out after letting my eyes rest a bit ...went through the code comparing it to the same code in another form (line for line ....syntax to syntax) and found the I left out a ( ' ) in the "VALUES line I the error was (" & Me.txtID & "," & Me.txt...) the error was in the RED text it should have been (" & Me.txtID & ",'" & Me.txt...) left out the apostrophe.

thanks again for your help..