How can I change value on a master form and have that value then update to a field on all lines in a subform form and then automatically recalculate another value on all subform lines based on that value coming in from the master form? I have searched my classes and don't seem to be able to find what I am looking.
Edward MastoloniOP 2 years ago
I got the field on the master form to update in the subform when it loads. Now I need to just get the subform to update when I change the value in the master form.
Edward MastoloniOP 2 years ago
Forget it. I figured it out. I just needed to requery the subform in the AfterUpdate event on the field in the Master Form. You guys rock! :)
Edward MastoloniOP 2 years ago
Actually I'm not done. After the subform is updated, how do I recalculate each line in the subform?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
TechHelp.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
