Art
Try this way:
[Forms]![frmWorkOrderDetails]![sfrmWorkorderParts]![Parts Total]
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> I have a a main form called frmWorkDetails which has to subforms called sfrmWOParts and sfrmWOLabor. On sfrmWOLabor there is a txtbox called [Labor Total] and on sfrmWOParts there is a textbox called [Parts Total]
>
> I am trying to reference the two fields in my report. The frmWorkDetails is open when I run the report but I get a #Type error in my txtTotal textbox on my report.
>
> Expression in the txtTotal box is:
>
> =Nz([Forms]![frmWorkOrderDetails]![sfrmWorkorderParts].[Form]![Parts Total])+Nz([Forms]![frmWorkOrderDetails]![sfrmWorkorderLabor].[Form]![Labor Total])
>
> What am I doing wrong?
>
> Thanks,
>
> Art Lorenzini
> Sioux Falls, SD
>
Tidak ada komentar:
Posting Komentar