By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,379 Members | 3,035 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,379 IT Pros & Developers. It's quick & easy.

Is there a way to sum a form without using requery?

P: 176
I have a regular continuous form, with a sum control at the form's footer. When I change one the rows that are calculated in sum, I need to preform a requery in order for the sum control to be updated, and it blinks the screen.

Is there any way to do that without using requery?
Thanks in advance.
Dec 24 '06 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,532
Instead of requery try Me.Recalc.
Dec 24 '06 #2

P: 176
Instead of requery try Me.Recalc.
Yeah, it is more correct to use it of course, and I think it works a bit faster. Thanks.
Dec 24 '06 #3

Expert 2.5K+
P: 3,072
An alternative might be to decrease the "Refresh Interval" from the default 60 sec's to e.g. 10 or 20.
Just select Tools>Options and the Advanced tab to set the property.

Dec 24 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.