Update Subforms

  • Thread starter RedHeadedMonster via AccessMonster.com
  • Start date
R

RedHeadedMonster via AccessMonster.com

I have a main form: ConfigUpdate that holds several subforms. One subform is
entitled Config the other is ConfigWorkTotals. What Im trying to do is
update / refresh / requery ConfigWorkTotals when an item is updated in Config.


I've tried several different things on the AfterUpdate:

Forms!ConfigUpdate!ConfigWorkTotals.refresh
Forms!ConfigWorkTotals.refresh

Keep getting the same message that it can't locate the form. What am I doing
wrong?

RHM
 
D

Dale Fye

How about, in the AfterUpdate event of the Config subform:

Forms!MainForm.sub_ConfigWorkTotals.Form.requery

Access no longer recognizes ConfigWorkTotals as an independent form when it
is a subform. So you have to refer to its parent, then you have to refer to
the subform CONTROL on the parent, then you need to refer to the FORM, and
then to the requery.

HTH
Dale
 
Top