Dan Waters
dwaters at usinternet.com
Fri Aug 8 08:49:09 CDT 2008
Hi Darryl, I think in reports you need to change label captions in the Format event. So, you need to call the module code from the Format event instead of the Open event. I think that during the main report's Open event, the subreport is inaccessible. Also, I'd recommend changing the name of your label from 'Budget' to 'lblBudget', or something else that's unique. You may have a textbox that is also called Budget, or a textbox could be bound to a field called Budget. This duplicate naming happens when you use a Report (or Form) wizard to create the Report (or Form). Good Luck, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Friday, August 08, 2008 1:47 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Sub Report Syntax... I should have mentioned that the code resides in a Module that is being called as part of the Report Open Event... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darryl Collins Sent: Friday, 8 August 2008 4:31 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Sub Report Syntax... Hi all, A dead easy one I am sure, but got a bad case of fried brain this friday afternoon. What is up with this syntax... [Reports]![rpt_ProjectSummary].[rpt_TL1].[Report].Budget.Caption = sBudget is returning "Invalide Ref to Property Form/Report", which would suggest a spelling or naming error, but I check that about 20 times already. Or do have the syntax all buggered for the subreport. I want to write the value of the string "sBudget" into a label (named budget) on the subreport. Can be that hard surely!!?? :) cheers Darryl. This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com