Form's ADO recordset does not load completely

  • Thread starter Thread starter Zachary Gleit
  • Start date Start date
Z

Zachary Gleit

I have noticed that when I requery a form based on a SQL
server table and then use "find" on the recordset, I get
an "eof" and the record isn't found, even though I know
the record I'm "find"ing is in the recordset. If I put
a "stop" in the VB code before the find, and then step
through the code, the eof doesn't occur (and the record
*is* found). Similarly, if I display a message box before
the find, the eof doesn't occur.

It's as if the form's recordset takes a while to load even
though the code keeps going before the recordset has
loaded.

Is there any way to pause until the recordset is
completely loaded so that I don't have this problem? It
doesn't work even if I keep re-finding when I get an eof.
 
Don't know if this will help but you can try

rs.movelast
rs.movefirst

after you open the recordset and determine that some records have been
returned.

Ron W
 
Back
Top