VB Forum / Database Access / April 2007

I have a puzzling issue.

I am receiving the compile error "Method or data member not found."
It's behaving erratically, and when you see the rest of my
explanation, you might see why.

In two different spots in the code, I'm comparing the field of a
record with a known value.

--------------------------------------------------------------------------
       dim rsLAssy as ADODB.Recordset
       Set rsLAssy = GetData(strSQL)

1        If myKnown > rsLAssy("Max") * 12 / myCompare Then GoTo
NextAssy
2        dTemp1 = rsLAssy("Max") * 12 / myKnown

.
.
.

3        If myInput > rsLAssy("Input") * 12 / myCompare Then GoTo
NextAssy
4        dTemp1 = rsLAssy("Input") * 12 / myInput
--------------------------------------------------------------------------

Variable names changed to protect the innocent.

Here's the odd part.  I'll get the compile error when the code looks
as it does above, and the rsLassy identifier from line 1 is
highlighted.  I couldn't see anything wrong with the identifier or the
data member name, so I commented line 1 and tried to proceed.  With
line 1 commented out, the program gives the compile error, but on line
3.  If I comment the line 3, there are no compile errors.

Can anyone see what I've done wrong?  I can't!

In the meantime, I'm going to try to change the way lines 1 and 3 are
written.

Thanks in advance,
Clint