Method or data member not found

[AdamFeerst]

I'm getting this compile error, on the code below, on .ChecklistID even though ChecklistID does exist on the form.

stSQL = "INSERT INTO tblChecklistData SELECT " & Me.ChecklistID & " As ChecklistID, TaskID FROM tblChecklistTasks WHERE tblChecklistTasks.ListID=" & Me.cmbListType

It compiles if I replace Me. with Form.

Why is that?

 

[sneuberg]

When you type

stSQL = "INSERT INTO tblChecklistData SELECT " & Me.

Does the intellisense show ChecklistID in the drop down?

 

[AdamFeerst]

Yes, intellisense does show ChecklistID

 

[sneuberg]

I replicated you situation on my system and found that it complains about Me.ChecklistID not being found when the real problem is Me.cmbListType.

I suggest checking the spelling of that.

 

[AdamFeerst]

Got it working. That spelling was fine, though I corrected something inside quotes. Not sure how that or whatever else I did fixed it, but I won't complain.

Thanks