Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / December 2005

Tip: Looking for answers? Try searching our database.

Add value to subform from main form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
luv4nrt@hotmail.com - 15 Dec 2005 22:04 GMT
Hello all, I have a membership dB in which I have a form that updates
data in 4 tables.  One of the tables is bounded to a subform within the
Main membership form.  I am trying to link all four tables, such that
when I input data on the Main form it automatically populates data on
all 4 tables.  I was able to update 3 of the four forms using the
SetValue (=) statement in the VB editor; however, I am not able to
update the data on the subform.  I am relatively new to VB and would
like to know what is the standard format to assign values to a control
within a subform based on data from the main form.  Also, does anyone
know what is a "really good" book that could help me with learning VBA.
Br@dley - 15 Dec 2005 23:30 GMT
> Hello all, I have a membership dB in which I have a form that updates
> data in 4 tables.  One of the tables is bounded to a subform within
[quoted text clipped - 7 lines]
> know what is a "really good" book that could help me with learning
> VBA.

Forms!MyMainForm!MySubFormControl.Form![MyControlOnSubForm]

If you are calling it from code in the main form you can simply use:

Me![MySubFormControl].Form![MyControlOnSubForm]

Signature

regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.