Calculated field taking a long time to appear

[branston]

I have a form with a subform. The subform is continuous with each record holding a frame with 3 options for each record. In the subform header i have some calulations counting how many are selected at the different options in the frame.
It works fine, but when i first go onto the form, or make any changes it takes a really long time for the calculated boxes to populate.
Is there any reason you can think of why this is happening? Or how to make it go quicker?!
Thank you!

 

[RuralGuy]

How are you doing the calculations?

 

[branston]

They are just unbound text boxes with the calculation in.

 

[DCrake]

What could be happening is that the calculations are based on other controls that appear in your underlying recordsource that is based on a query. Everytime the record changes the calculation is fired and unbeknown to you the query is being executed/requeried. So it is the time it takes to refresh the query that is causing the delay. Then again I might be completely wrong, without seing it for myself I can only assume.

David

 

[RuralGuy]

What is the calculation?

 

[branston]

Hum, yeah, that could be it. I spose that means i just have to deal with it?!

 

[smig]

I have a similar problem - real long time to show data in calculated fields.
so I decided to reopen this thread.

the calculated fields are realy simple calculate (Money*Quantity) on a continious subForm.
when I load the form it can take 2 or 3 minutes to show all calculated fields.
db is not very big and hold 10,000 records only.
surprizingly if I AltTab to switch to another aplication and AltTab back it immidietly finish the claculations and show all data corect

I have this problem only on the computers at the office I'm creating the db for.
I guess it's not network related as it's also on the machine where the db sit on, and work localy. I l also tried to move it localy to another computer with no help. trying to disable all running tasks - anti virus, backup... didn't help either.
All machines are P4, 3.2gHz, 1gb RAM.

 

[RuralGuy]

What version of Access and what OS? Are both up to the current patch level with all HotFixes applied?

 

[smig]

MS Access 2003
WinXP SP2

do you know about HotFix that might fix this issue ?

 

[RuralGuy]

WinXP is up to SP3 and Office 2003 is up to SP3 with a HotFix. You could easily be dealing with a problem that has already been resolved.

 

[smig]

this is not the cause for the problem.
I have no such issue on machine with WnXP SP2 and Office 2003 SP2

not sure if it will help or not (will have to test it in the user office) but I though trying to create the calculated field as part of the query under the form and not on the form fields.