From: Klatuu on
Nor have used ADO. Perhaps I wasn't clear enough. I did not mean to say
that it is only ADO.

"Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in message
news:upqDlh8WKHA.3720(a)TK2MSFTNGP02.phx.gbl...
> "Klatuu" <dahargis(a)verizon.net> wrote in message
> news:%23lu5UG8WKHA.3696(a)TK2MSFTNGP02.phx.gbl...
>> Use the FindFirst. You code is DAO code, but Seek is actually an ADO
>> method.
>
> David, I don't think I would put it this way. Both the DAO and ADO
> Recordset objects have a "Seek" method. They have slightly different
> restrictions, though, related to the differences between DAO and ADO. As
> you mentioned, the DAO Seek method can only be used with a table-type
> recordset, while the ADO Seek method can only be used with a server-side
> cursor *and* a command-type of adCmdTableDirect. (I got the ADO
> information from the help file; I've never used the ADO Seek method.)
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>