Calculate a Subform on Command

[GlenMacK]

I have form with a couple of subforms. One of them is taking a long time to calculate, which means it is taking a long time to move between records.

Is there any way that I could have the subform showing on the form, but not have it calculate until a command button is pushed. This way a user can move through records quicker and only total the records they want instead of each one.

Any help on this would be greatly appreciated.

 

[Rolliee]

Sure! The same commands you are using to calculate the values can be put under a cmd button. Just be sure any alias' that you are using - namely 'me' is changed to it's formal name 'forms![...]....'


Rollie

 

[GlenMacK]

So what you are saying is instead of having the calculations performed in the query for the subform, have a command button perform the calculations.

I will try that , thanks..I think one problem I may with that is...my query for the subform is made of two other querys..probably bad programming on my part.

I am sum totalling hours and Materials both of which come from separate querys...

Not sure how I will get all to calc...

Thanks for pointing in the right direction..

 

[Rolliee]

Separate queries are no problem.

R