I have a report called rptReference, rptReference has a subreport called rptLookupC, rptLookupC has a subreport called rptOutcomeC,that's:

rptReference
---rptLookupC
--------rptOutcomeC

In rptOutcomeC, there is a textbox called txtSdOrCdValue, the Sd value and cd value both come from tblTrial(see below)

tblTrial
ID SD value CD value
1 1.2
2 3.4
3 4.5
4 8.0
5 7.4

Either SD or CD has a value, but never both have values. The following is what the report would look like:

ID txtSdOrCdValue
1 SD=1.2
2 CD=3.4
3 SD=4.5
4 SD=8.0
5 CD=7.4

QUESTION:
1:How to refer to txtSdOrCdValue in VBA code? coz it is in the subReport, I have no idea how to do it?
2:Any method to fill in txtSdOrCdValue with SD or CD?

Thanks a lot

You can do this in the Detail section's On Format event.
Add the SD and CD fields to the subreport, and set their visible property to No.

Add code like this to the On Format event of the subreport:

If IsNull(Me.SD) Or Me.SD = "" Then
   Me.txtSdOrCdValue = Me.CD
Else
   Me.txtSdOrCdValue = Me.SD
End If

This should work, although there may be a problem with taking a value from a control like this at runtime. To fix that, take the value of SD and CD using conditionals, and then pass them to the txt control with a conditional.

Did that help?



mmcdonal