[MS_AccessPros] Reference a suform in a report

 

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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 9
• New Links 1
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___