Referencing a subform control on a subreport

[Yam84]

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?

 

[g]

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