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

Please help in how to update subforms

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.