Thanks Crystal! Another quick question on controls and expressions...
I have a calculated control - Part_Cost, which is -
=[Quantity]*[Unit_Price]
In the footer of the subform I put a new control - Total_Cost
=Sum([Part_Cost])
Essentially I want it to total the Parts Costs for each line.
It's not working, so more than likely I am missing something!
Thanks!
Deb
On Sat, Sep 3, 2011 at 8:37 PM, Crystal <strive4peace2008@yahoo.com> wrote:
> Hi Deb,
>
> a control on another form can have this Controlsource -->
> = forms!formname!controlname
>
> you can also put that reference into an equation on another form:
> = (forms!formname!controlname + 1) * 99
>
>
> if the control you are trying to reference is on a subform:
> = forms!formname!subform_controlname .form!controlname
>
>
> Warm Regards,
> Crystal
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar