Display subform confrol total to mainform (1 Viewer)
- Thread starter moi
- Start date
Gasman
Enthusiastic Amateur
- Local time
- Today, 01:07
- Joined
- Sep 21, 2011
- Messages
- 15,534
Sir it gives me "#Error. This is what i enter in textbox in main form.. =[Form]![sbfrm_payment]![txtmonthlytotal]
June7
AWF VIP
- Local time
- Yesterday, 16:07
- Joined
- Mar 9, 2014
- Messages
- 5,595
I already provided syntax. So with your object names, try:
=[sbfrm_payment].Form.[txtmonthlytotal]
This assumes sbfrm_payment is name of container control. Container control might have same name as the form it holds. I always assign a different name.
=[sbfrm_payment].Form.[txtmonthlytotal]
This assumes sbfrm_payment is name of container control. Container control might have same name as the form it holds. I always assign a different name.
Yes sir, i wrongly address the control name.. Pls bear with me, i just started learning ms access.. If you know/have a link where i can download a demo db having the basic features for me to disect and learn from it, it would be appdeciated.. Thank you for time.
June7
AWF VIP
- Local time
- Yesterday, 16:07
- Joined
- Mar 9, 2014
- Messages
- 5,595
There are sample databases and templates in many places on the web.
One commonly used in tutorials is Northwind
https://support.microsoft.com/en-us...1de-8278-1afcfc91a9cb?ui=en-us&rs=en-us&ad=us
https://support.microsoft.com/en-gb...-edition-32eb79d2-bede-4ea4-b575-0714ca8dc1e2
One commonly used in tutorials is Northwind
https://support.microsoft.com/en-us...1de-8278-1afcfc91a9cb?ui=en-us&rs=en-us&ad=us
https://support.microsoft.com/en-gb...-edition-32eb79d2-bede-4ea4-b575-0714ca8dc1e2
AccessBlaster
Registered User.
- Local time
- Yesterday, 17:07
- Joined
- May 22, 2010
- Messages
- 6,567
I removed the second "dot" and replaced with the "bang" and removed the brackets around the textbox.
=[sbfrm_payment].Form!txtmonthlytotal
=[sbfrm_payment].Form!txtmonthlytotal
many thanks..
June7
AWF VIP
- Local time
- Yesterday, 16:07
- Joined
- Mar 9, 2014
- Messages
- 5,595
Either work but bang will prompt list of object names whereas dot lists properties.
In VBA the dot will provoke intellisense listing properties and in some situations object names as well.
Access will likely throw the brackets back in.
In VBA the dot will provoke intellisense listing properties and in some situations object names as well.
Access will likely throw the brackets back in.
Cotswold
Active member
- Local time
- Today, 01:07
- Joined
- Dec 31, 2020
- Messages
- 674
Take a look at the following:
Language reference for Visual Basic for Applications (VBA)
Conceptual overviews, programming tasks, samples, and references to guide you in developing solutions based on Visual Basic for Applications.
learn.microsoft.com
In the Access Programmers forum see:
Code Repository
Microsoft Access Tutorials
Sample Databases
See if you can get hold of a copy of Access 2000 Developers Handbook Volume 1 by Litwin, Getz & Gilbert
Even the Access 97 version of the same book will be worth buying if you cannot buy the 2000 one. Both old but much is still applicable today.
(don't be tempted with Volume 2 just yet).
Unfortunately they do not do books like that now. In fact they don't write Access books for programmers at all. There are other later books printed but not of the same standard. Today only a few for the Dummies who hope to use Access by clicking around the menus and ribbon here and there.
Maybe also do searches on this forum? Anything you want to know you can safely assume will have been asked many times before. Even an internet search should give results. But better to get the spelling right in your searches.
Last edited:
Cotswold
Active member
- Local time
- Today, 01:07
- Joined
- Dec 31, 2020
- Messages
- 674
Presume it wasn't much help beyond a few days?In fact, my bosses a few years back, bought me Access 2007 for Dummies.
