Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 6th, 2007, 12:12 PM
Authorized User
Join Date: Oct 2003
Posts: 25
Thanks: 1
Thanked 0 Times in 0 Posts
Default #Error displayed in text box on report

I have a subreport [PackSlipDtl] that displays line item values. [TotValue]
In the subreport footer, I have a text box [txtSumTotValue]to calulate the total of the line items. The control source is set to =Sum([TotValue]).

On the main report, I have a text box to display the Sum and the control source is set to PackSlipDtl!txtSumTotValue

When I run the report, the text box on the main report displays #Error.

Can someone help with this?

Thanks .... Ray

Old March 7th, 2007, 08:27 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

You are not using the right bang dot syntax.

Open the Northwind database, and check the invoice. You need to refer to the subform as an object within the main form. Northwind uses:

=[Orders Subform].Form!OrderSubtotal

Did that help?

Old March 9th, 2007, 12:04 PM
Authorized User
Join Date: Oct 2003
Posts: 25
Thanks: 1
Thanked 0 Times in 0 Posts

Thanks for the help. That worked. .... Ray

Old March 16th, 2007, 07:12 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

I was under the impression the bang ! was obsolete and that Access works with all dots now. The dot also invokes autotext completion while writing VBA whereas the bang does not.

I do know it still works in VBA, but is it still useful and/or necessary? I don't have bangs in any of my databases. All run quite well.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating VBA calculated Text Box throught Report wintermute Access VBA 2 March 28th, 2008 12:00 PM
Large report in text box takabyte Beginning VB 6 3 August 6th, 2007 07:32 PM
How to change the width of text box in a Report kishorelakkimsetty Reporting Services 3 May 13th, 2006 01:50 PM
Assigning a value to a report text box using VB Enoch Access 2 January 19th, 2006 01:57 PM
text displayed incorrectly kmfdm515 ASP.NET 1.0 and 1.1 Basics 0 December 13th, 2004 01:22 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.