Hello Everyone,

Do you know how to show the total amount of of a subform field amounts in master form?

My Master Form: Project. Fields are ID (primary key, autonumber), projectname, projectmanager, schoolyear...
SubForm: ProjectDetail. Fields are ID (Primary key, autonumber), subobject, Title, EstimatedAmount, descr...
Forms are linked by ID.

I need to put the Total EstimatedAmount as a text box in Master Form below the subform. When EstimatedAmount in subform changes, the Total EstimatedAmount in Master project form has be always changed.

I tried using query, or macro, but it didn't work.

Thanks,
Cindy

Cindy,

There is no Marco, query or VBA code required to handle this.

What version of Access are you using?

In the Northwind sample database the Orders form does exactly what you want.

This basic idea is this:

1) on the sub form use a hidden form footer with a text box that holds the sum.

2) On the parent form set the control source of a text box to reference the control in the sub form's footer.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Thank you so much, HiTechCoach!
It works:-).

Cindy

You're welcome!

Glad we could assist.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015