Queries run in background

[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..

 

[Gerald Stanley]

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

Hope This Helps
Gerald Stanley MCSD

 

[TC]

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

 

[TC]

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

TC