Please help in how to update subforms

[JJMM]

Hi,

I have a form (form1) with a large number of subforms inside it (around 20
subforms), There is the possibility of filtering the data using a pop-up
form that create/change a query (all the subforms are linked to that query),
Once that I create/change the query (using the pop-up form), Is there any
easy way to update all the
20 subforms inside form1?.

Normally I use to change the recordsource in each subform to show the
changes, but since there are 20 subforms (each one with a sql recordsource)
it will be lot of work, so I am lookong for an easy way.

Thanks,

Jaime

[PaulT]

If I'm reading you correctly, the query of form1 is used by the other
20 subforms after a change?

If that's true, then I'd add some VB code to the AfterUpdate() event
of form1 to refresh the other forms sequentially the way they need to
be refreshed...

Forms![subform1's name].requery
Forms![subform2's name].requery
Forms![subform... name].requery
Forms![subformN's name].requery

Hope this helps.

-Paul

"JJMM" <jj**@ya.com> wrote in message news:<bj**********@news.ya.com>...

Hi,

I have a form (form1) with a large number of subforms inside it (around 20
subforms), There is the possibility of filtering the data using a pop-up
form that create/change a query (all the subforms are linked to that query),
Once that I create/change the query (using the pop-up form), Is there any
easy way to update all the
20 subforms inside form1?.

Normally I use to change the recordsource in each subform to show the
changes, but since there are 20 subforms (each one with a sql recordsource)
it will be lot of work, so I am lookong for an easy way.

Thanks,

Jaime