By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,225 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,225 IT Pros & Developers. It's quick & easy.

Problem with Totals on Sub Forms and Main Forms

P: n/a
I have an access data project (MS-SQL Svr 2000 backend and MS-Access 2003
Front End) that has a sub-form based on a query view. On the sub form I have
several column's in which I have a running total on the sub-form footer.
This part works fine.

My problem is that the main form, on which the sub-form resides, I want to
display the total from the sub-form total calculation. I have tried
referencing the control on the sub form, i.e. My.Somecontrol =
Forms![formname].[controlname] but this does not work.

How do you make this works. Do I have to do something different because this
is an access project instead of an mdb?

Thanks in advance for any help!!

Mike
m charney at dunlap hospital dot org
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Mike:

The following KB article may be a good reference.

http://support.microsoft.com/default...b;en-us;209099

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Mike" <no***@forgetit.com> wrote in message
news:kw***************@newssvr22.news.prodigy.net. ..
I have an access data project (MS-SQL Svr 2000 backend and MS-Access 2003
Front End) that has a sub-form based on a query view. On the sub form I have
several column's in which I have a running total on the sub-form footer.
This part works fine.

My problem is that the main form, on which the sub-form resides, I want to
display the total from the sub-form total calculation. I have tried
referencing the control on the sub form, i.e. My.Somecontrol =
Forms![formname].[controlname] but this does not work.

How do you make this works. Do I have to do something different because this
is an access project instead of an mdb?

Thanks in advance for any help!!

Mike
m charney at dunlap hospital dot org

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.