Referencing a subform control on a subreport

Hello,

I would like to copy a calculated control of an unbound control on to
a report. On my form (F_SampleRequest) i have a button which opens
the report. Here is the code for the button:

Private Sub btnOpenSampleReport_Click()

DoCmd.OpenReport "R_SampleRequest"
'Open Report SampleRequest


Reports!R_SampleRequest.SR_SampleReqRep.Report!txtRptWat =
SF_MixSample.Form!ListWater
Reports!R_SampleRequest.SR_SampleRequest.Report!txtRptWaterReq =
SF_MixSample.Form!txtWaterReqWt

End Sub

My report contains a subreport (SR_SampleReqRep) which has 2 text
boxes (ListWater and txtwaterReqWt) which I wish to be copied into
from the SF_mixSample subform. This code prints the report as opposed
to copying the information into the report. I have used similar code
to copy from one form to the next, so I thought i could do the same
with a report and subreport. How can I copy a value from a subform
to a subreport?

Hi, Just giving your problem a try.

On your fields at sub report enter on each control source

For ListWater:
=Forms!YourMainFormName.SF_MixSample.Form.ListWater

For txtwaterReqWt
=Forms!YourMainFormName.SF_MixSample.Form.txtWaterReqWt



"Yam84" wrote:

> Hello,
>
> I would like to copy a calculated control of an unbound control on to
> a report. On my form (F_SampleRequest) i have a button which opens
> the report. Here is the code for the button:
>
> Private Sub btnOpenSampleReport_Click()
>
> DoCmd.OpenReport "R_SampleRequest"
> 'Open Report SampleRequest
>
>
> Reports!R_SampleRequest.SR_SampleReqRep.Report!txtRptWat =
> SF_MixSample.Form!ListWater
> Reports!R_SampleRequest.SR_SampleRequest.Report!txtRptWaterReq =
> SF_MixSample.Form!txtWaterReqWt
>
> End Sub
>
> My report contains a subreport (SR_SampleReqRep) which has 2 text
> boxes (ListWater and txtwaterReqWt) which I wish to be copied into
> from the SF_mixSample subform. This code prints the report as opposed
> to copying the information into the report. I have used similar code
> to copy from one form to the next, so I thought i could do the same
> with a report and subreport. How can I copy a value from a subform
> to a subreport?
>