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

How do i update a subforms subform?

P: 1
Hi I'm using access 2003. I have a main form, with a tab control that has a subform with a subform. When I select an option from a combo box on the first tab of the tab control I need a field in the subform and subsubform to update. So far I can get it to work, but only the first record in the subsubform updates - the subsubform is display as a continuous form. I am using the following as an event from the combo box
Expand|Select|Wrap|Line Numbers
  1. [frmActionPlanHeader].Requery
  2. [frmActionPlanHeader]![frmActionPlanDetails subform].Requery
Jan 18 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 12,366
Expand|Select|Wrap|Line Numbers
  1. [frmActionPlanHeader]![frmActionPlanDetails subform].Form![some other subform].Requery
Jan 18 '12 #2

Expert Mod 15k+
P: 31,492
You should be able to work it out from Referring to Items on a Sub-Form, but in this case, where we don't know the name of your sub-sub-form it could be :
Expand|Select|Wrap|Line Numbers
  1. [frmActionPlanHeader].[frmActionPlanDetails subform].Form.[Some Other Subform].Form.Requery
or, alternatively :
Expand|Select|Wrap|Line Numbers
  1. [frmActionPlanHeader].[frmActionPlanDetails subform]![Some Other Subform]!Requery
Jan 18 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.