Update Subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RedHeadedMonster - 30 Apr 2008 14:54 GMT

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

Reply to this Message

Al Campagna - 30 Apr 2008 15:58 GMT

RHM,
Try a Refresh against Config, but a Requery against ConfigWorkTotals.

Signature

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."

>I have a main form: ConfigUpdate that holds several subforms. One subform
>is
[quoted text clipped - 12 lines]
>
> RHM

Reply to this Message

Dale Fye - 30 Apr 2008 16:36 GMT

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

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

> 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
[quoted text clipped - 9 lines]
>
> RHM

Reply to this Message