Bogus 'Method or Data Member not found' message

[gazolba]

I just changed some code and went to compile my database.
I'm getting an error 'Method or Data Member not found' on a reference to Me.txtJobStep. The value does exist, its even listed in the prompts when you enter Me.
How can I get rid of this bogus error?
If I remove that line, the error occurs on a nearby line.

I am totally stuck on this project and can make no progress.

 

[PHV]

Take a look here: faq705-4683

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[gazolba]

Thanks for the response.
I ran the 'compact and repair' and the error is still there.

 

[gazolba]

I found out what this was. I had a statement like:

strSQL = ............... & _
............... & _
............... & _
etc. etc.

The error pointed to the wrong data item. I did have a mispelled variable but the error pointed to the wrong one. I guess it got confused by the concatenation. Microsoft's incompetence cost me half a day in lost productivity.