Art
I'll let you call yourself an idiot. I know I call myself an idiot serveral times a day when I'm writing code. :O)
Bill
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> Bill,
> I can take it, call me and idiot! I had the field names wrong!
> Â
> =Nz([Forms]![frmWorkOrderDetails]![sfrmWorkorderParts]![Total Parts])+Nz([Forms]![frmWorkOrderDetails]![sfrmWorkorderLabor]![Total Labor])
> Â Thanks for all your help!
>
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
>
>
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, April 4, 2012 4:14 PM
> Subject: [MS_AccessPros] Re: Reference a suform in a report
>
>
>
> Â
>
> 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
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar