Update Subforms

[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

 

[Al Campagna]

RHM,
Try a Refresh against Config, but a Requery against ConfigWorkTotals.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[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