Correct error message

[MikeR]

I have an Access 2000 mdb back end for a Delphi program, and use DAO to stir the db.

If I do a FindFirst on a recordset that does not contain the value I'm seeking, I get
a 'The Microsoft Jet database engine does not recognize CID as a valid field name or
condition.' message.

The seek is ListRec.FindFirst(CID = "K"). CID is a field of the table.

Why that particular message rather than just a nomatch condition?

Thanks,
Mike

 

[Tom van Stiphout]

On Sun, 19 Jul 2009 12:58:16 -0400, MikeR <[email protected]>
wrote:

Check to make really sure CID is a field in ListRec by iterating over
the Fields collection.

-Tom.
Microsoft Access MVP

 

[MikeR]

Thanks Tom -
As I said, CID is a field. The record set is ALWAYS opened with a query like 'Select
* from ListRec' some times with a where clause, sometimes not.

 

[MikeR]

Got it in one, Tom.
Just before doing my FindFirst, I opened the recordset without including CID.
Thanks!