Thanks Jamie


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jamie Collins" wrote in message oups.com...

Ron de Bruin wrote:
Is this reliable? I have always used...

If Not rsData.BOF then rsData.MoveFirst....

I don't use it very much myself and Rob bovey helped me make this
example.
I have never have problems with it but you good be right.
Maybe a ADO expert can tell us ?

I lieu of an ADO expert... When opening an ADO recordset the position
will either be at row 1 (the equivalent of MoveFirst) or at EOF is
there are no rows. DAO behaves slightly differently from ADO e.g. in
DAO you have to MoveLast to get an accurate RecordCount but it's always
reliable in ADO. Perhaps OJ's code is a DAO hangover?

Jamie.

--