asked on

How do I autoupdate a field on a mainform with a calculated value on subform footer

I need to have a calculated value from a subfrom footer autoupdate the value of a field in my mainform. Main form is "AuditMainTable" and field name is "FinancialAccuracy". The subform has a field called "Total" for each record. In the subform footer I have a calcuated value of "Total" I need ths value to update the MainForm field anytime it is updated.

Rey Obrero (Capricorn1)

see this link

How to Bring a Subtotal from a Subform to a Main Form
http://support.microsoft.com/?kbid=208998

peter57r

What is the nature of the subform and its total?

Is it a continuous form with the total being the sum of a single field ( like =sum(myvalue) ) or is the subform a single form with the 'total' being based on several fields in the one record?
Or something else?

The technical issue is to find an event that occurs as the total changes and this requires more detail about the subform andhow the total is calcuated.

jacobtdad

ASKER

Peter57r, it is a continuous form. I tried using Me.Parent.FinancialAccuracy = Me.Text100 in the after update , change event and the only way it will work is if I exit the clic on a field in the Mainform again or add the code to the doubleclick event

ASKER CERTIFIED SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial