[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.
>  
> Any ideas?
>  
> Thanks,
> Mark Boyd
> I/S Supervisor
> McBee Associates, Inc.
> 610/964-9680 x15
>  
> -----------------------------------------
> This message and any attachments are intended only for the 
> use of the individual or entity to which it is addressed and 
> may contain information that is privileged, confidential, and 
> exempt from disclosure under applicable law. If the reader of 
> this message is not the intended recipient, or the employee 
> or agent responsible for delivering the message to the 
> intended recipient, you are hereby notified that any 
> dissemination, distribution or copying of this communication 
> is strictly prohibited. If you have received this 
> communication in error, please notify the sender by replying 
> to this message, and then delete it from your system.
> -------------------------------------------