compile error Method or data member not found

[gunterbrink]

Private Sub cmdJLAddJob_Click()
'when we click on button Add there are two options
'1 for insert and 2 to update
If Me.txtJLID.Tag & "" = "" Then
'this is insert new

'Add data
CurrentDb.Execute "INSERT INTO joblog_list(Job ID, Company Name, Company Rep Day, Company Rep Night, Well Name, Job Date) " & _


" VALUES(" & Me.txtJLID & ",'" & Me.cboCoJLName & "','" & Me.cboJLCoRepDay & "','" & _
Me.cboJLCoRepNight & "','" & Me.cboJLJobDate & "')"


Me.txtJLID is giving the error

Any suggestions

[pbaldy]

In my experience, it could be any of the form references in that line. Check the spelling of all of them.

[gunterbrink]

All seem to be spelled correctly. It highlights the txtJLID. I checked the reference on the form and the text box is named txtJLID, so I don't see the issue?

[gunterbrink]

So I have fixed the compile error, now I get this?
Runtime error 3134
Syntax error INSERT INTO

[pbaldy]

One of them spelled wrong, or? The field names with inadvisable spaces need to be bracketed. This may also help:

http://www.baldyweb.com/ImmediateWindow.htm

date/time fields need # as the delimiter, not '.

[CJ_London]

may not be the reason for your error, but your sql doesn't look correct - you have spaces in your field names, so need to use square brackets. Also you are wanting to populate 6 fields, but only providing 5 values.

And if your previous reference here

If Me.txtJLID.Tag & "" = "" Then

works, then it is likely the error message is misleading

[Missinglinq]

I believe the original problem came about because of a missed space. I think that

" VALUES(" & Me.txtJLID

should have been

" VALUES (" & Me.txtJLID

[pbaldy]

Doubt it. That would cause an execution error, not a compile error.

[Jomar]

How were you about to solve this ? I am currently having th same problem

All seem to be spelled correctly. It highlights the txtJLID. I checked the reference on the form and the text box is named txtJLID, so I don't see the issue?

[John_G]

Try changing Me.txtJLID to Me!txtJLID, i.e. use the "!" instead of "."

Access is getting more and more finicky about this, and it has given me errors for the same thing.