[AccessD] Referencing Fields in Sub-Reports

Gustav Brock Gustav at cactus.dk
Wed May 18 09:23:24 CDT 2005


Hi Mark

Your problem is that the control doesn't even "exist" when there are no
records.
Thus, you may need something like this (one line):

  IIf(Report!rptMain!<sub1>.Report.RecordsetClone.RecordCount = 0, 0,
Report!rptMain!<sub1>.Report!txtTextbox) +
  IIf(Report!rptMain!<sub2>.Report.RecordsetClone.RecordCount = 0, 0,
Report!rptMain!<sub2>.Report!txtTextbox)

/gustav

>>> MarkBoyd at McBeeAssociates.com 05/18 3:43 pm >>>
Thanks Andy and Gustav.
Using the syntax "rptSub1.Report.txtTextbox +
rptSub2.Report.txtTextbox"
seems to work.  Although, this only totals the values when there are
legitimate values in each textbox.  If one of the boxes contains a
null
value, the report is showing "#Error" in the field.
I'm thinking that I want to force the subform's textbox value to 0 if
it's null, but this doesn't seem to be working.  I tried using
"=IIf(IsNull([TextboxValue]),0,[TextboxValue])", but this still
displays
a null value.

Does this make sense?
Thanks,
Mark Boyd
I/S Supervisor
McBee Associates, Inc.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav
Brock
Sent: Wednesday, May 18, 2005 4:08 AM
To: accessd at databaseadvisors.com 
Subject: RE: [AccessD] Referencing Fields in Sub-Reports

Hi Mark and Andy

There used to be a document on the DBA site which listed how to
reference parent and child forms and reports.
Where did it go??

But it should go like this:

  Report!rptMain!<NameOfSubreportControl1>.Report!txtTextbox +
  Report!rptMain!<NameOfSubreportControl2>.Report!txtTextbox

/gustav

>>> andy at minstersystems.co.uk 05/18 8:28 am >>>
Mark
I think the ref within rptMain would just be to

Me.subrpt1.report!txt1

Remembering that subrpt1 is the subform control within rptMain not the
report name.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Boyd
> Sent: 17 May 2005 22:59
> To: AccessD at databaseadvisors.com 
> Subject: [AccessD] Referencing Fields in Sub-Reports
> 
> 
> How can I reference values in textboxes that are located in 
> sub-reports? I have a report (rptMain) with 2 subreports
> (rptSub1 and rptSub2).  Each subreport only contains 1 textbox.  I 
> want to grab the values from each textbox in the
> 2 subreports, and display a total of the values on my main report, 
> rptMain. I can't figure out how to enter the Control Source of the 
> textbox on my main report.  With forms, I would just use 
> "Forms!frmMain.frmSub1.Form.txtTextbox + 
> Forms!frmMain.frmSub2.Form.txtTextbox", or something of this nature. 

> I can't figure out how to do this with reports.




More information about the AccessD mailing list