Queries run in background

  • Thread starter Thread starter Steve Lloyd
  • Start date Start date
S

Steve Lloyd

Hi, I am having a problem when i open a new form and want to run some code
against the recordset in the Load event. The actual query seems to run in
the background and asynchronously, meaning that my load event is running
against an unpopulated or outdated recordset.

Does anyone know if i can turn the background query off or this "feature"
built into Access or... am i just missing something.

Thanks for any help

Steve..
 
Processing against the recordset should usually take place
in the Current eventhandler, not the Load event handler.

Hope This Helps
Gerald Stanley MCSD
 
Huh? That would re-do the processing whenever you moved from record to
record. If you wanted to do the process >once<, Form_Load is the way to go.

HTH,
TC
 
I doubt that the query runs "in the backgroyund". What is leading you to
conclude that?

TC
 
Back
Top