Darryl Collins
Darryl.Collins at coles.com.au
Fri Aug 8 01:47:18 CDT 2008
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.