Completed Queries

[jwells]

I'm using the load event and executing some code on the records returned from
an SQL query that is the rowsource for the form but not all of the records
have been retreived by the time the code executes. I've read that I need to
use .MoveLast to force access to wait till the last record is loaded but this
is not working. I'm still getting 521 records out of 2096 in the query. I
have all 2096 after the form has loaded. Can any tell me what I might be
doing wrong?

 

[John W. Vinson]

I'm using the load event and executing some code on the records returned from
an SQL query that is the rowsource for the form but not all of the records
have been retreived by the time the code executes. I've read that I need to
use .MoveLast to force access to wait till the last record is loaded but this
is not working. I'm still getting 521 records out of 2096 in the query. I
have all 2096 after the form has loaded. Can any tell me what I might be
doing wrong?

Not unless you tell us what you're doing! Please post your code, or the
relevant part of it.