Dan Waters
dwaters at usinternet.com
Tue May 17 18:09:52 CDT 2005
Hold On! Mark has been an innocent bystander in the great Global Variable War! We can treat him with respect. Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Tuesday, May 17, 2005 6:00 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Referencing Fields in Sub-Reports May I suggest a global variable? They must be good for something! <VBG> John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Boyd Sent: Tuesday, May 17, 2005 5:59 PM 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. ------------------------------------------- -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com