Is it possible to have a subform update it's contents based on user changes made to another subform? I've been trying for days to get the control on the subform to update but I can't get it to update correctly. Someone even suggested I may be "pushing the limits" of MS Access by overdesigning my main form. Maybe... but I don't think so. What do you think?
I am posting my db. Note that I have deleted some subforms in order to reduce the size to meet uploading limits.
If you look at the main form (frmProposalSetup), it has a tab control with several pages. On the WBS page, if I change the hours under PM (Program Manager) at the "Kickoff Meeting" task, I want to be able to click over to the LABOR page and see the corresponding Labor Hours under PM reflect the change in hours.
At one point I have tried adding forms.frmPROPOSALSetup.subfrmPROPOSALSetup.Form.Requery to the After Update event of the hours field on the subform that is suppose to drive the update (subfrmWBS) but that didn't work.
Does anyone have any other ideas? I doesn't seem like something that would "push the limits" of Access...
I appreciate anyone's input.
Thanks!
I am posting my db. Note that I have deleted some subforms in order to reduce the size to meet uploading limits.
If you look at the main form (frmProposalSetup), it has a tab control with several pages. On the WBS page, if I change the hours under PM (Program Manager) at the "Kickoff Meeting" task, I want to be able to click over to the LABOR page and see the corresponding Labor Hours under PM reflect the change in hours.
At one point I have tried adding forms.frmPROPOSALSetup.subfrmPROPOSALSetup.Form.Requery to the After Update event of the hours field on the subform that is suppose to drive the update (subfrmWBS) but that didn't work.
Does anyone have any other ideas? I doesn't seem like something that would "push the limits" of Access...
I appreciate anyone's input.
Thanks!
Attachments
Last edited: