Refreshing Parent Form (Easy - I think)

Posted on 2011-05-11
Last Modified: 2012-05-11
This should be easy and I am sure I have done similar before.
However, I have tried numerous variations and all fail.

Click frmMainBig.
Note the yellow fields on the right.
CHange the Qty from 1 to 2.
This will double the "Line Value" field (correct so far).

However, the "Net Total" lower down is NOT refreshed.
(It IS correct if you exit the form and re-enter.  Underlying calculations are fine)

Question: How do I get this field to Refresh?
Question by:Patrick O'Dea
    LVL 18

    Assisted Solution

    Try to requery the controls
    LVL 77

    Assisted Solution

    Adding more detail to the first response..

    Use the afterupdate evnet of the quantity field...

    Private Sub Qty_AfterUpdate()
    Me.Parent.[net total].Requery
    End Sub
    LVL 18

    Expert Comment

    Thanks peter57r
    LVL 119

    Accepted Solution


    you can try

    Private Sub Qty_AfterUpdate()
    End Sub

    the Recalc will immediately updates all the calculated controls in the form

    Author Closing Comment

    by:Patrick O'Dea
    Thanks all,

    It works perfectly now!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    758 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

    11 Experts available now in Live!

    Get 1:1 Help Now