We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Sum field in form footer does not refresh

psatkar
psatkar asked
on
Medium Priority
419 Views
Last Modified: 2013-11-28
Hello,

I have a very simple Continuos Form based on a query displaying 8 columns. One of the column displayed is "Account_Balance". In the form footer, I have a textbox control with control source defined as =sum([Account_Balance]).

When the form is opened, the text box in the footer remains blank. However, If I switch between open windows (using Alt+Tab), the field is found to be updated when I bring the focus back to MS Access window!!!

Has anyone encountered problem like this?

Thanks and regards,
--Prasad
Comment
Watch Question

Commented:
Hello,

I have, but only in forms with some complex code behind them. You say that the form is "very simple", but is it used a subform? is it a dialog box? do you have any code behind it? how many records does Access need to Sum()?

This is an idea: if you are summing 100000 records, or if your query is complex or not very optimized, Access can very well display the first record quickly, but take some time to compute the total. Try to display the navigation buttons, and check how long it takes for the record count to appear.

In code, you can force the refresh with Me.Refresh (identical to F9).

(°v°)
Commented:
Try in the Current_Event of the form to use

     Me.Form.Recalc

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks Karramli,
I have added Me.Form.Recalc in OnLoad event of this form and it has done the trick.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.