Performing simultaneous operations

[EvilCabal]

Hi,

I have a form that contains a subform. Info on the subform is the result of some complex calculations that takes a couple of seconds for access to perform. Problem is that each time the user change something on the main form, everything on the subform must be recalculated and this takes a lot time.

What I would like to do is to let the user do is things while access perform the calculations because right now it freezes the database during the calculation. Is there a way to make access perform a routine in the background while processing other user inputs at the same time?

Any help appreciated.

 

[SgtJarrow]

Don't think you can do it.....Access (Jet really) is the culprit here and there is no work around I am aware of....

This is the same principle as when you open a report, a query, or even run some VBA code....until the process is complete, Jet locks control of the database and you can't do anything until it is complete. Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCSA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com