Sum field in form footer does not refresh

Posted on 2009-02-11
Last Modified: 2013-11-28

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,
Question by:psatkar
    LVL 58

    Expert Comment


    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).

    LVL 1

    Accepted Solution

    Try in the Current_Event of the form to use



    Author Closing Comment

    Thanks Karramli,
    I have added Me.Form.Recalc in OnLoad event of this form and it has done the trick.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now