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

Add value to subform from main form

P: n/a
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.

Dec 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Br
lu*****@hotmail.com wrote:
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.

Forms!MyMainForm!MySubFormControl.Form![MyControlOnSubForm]

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

Me![MySubFormControl].Form![MyControlOnSubForm]

--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Dec 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.