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

Disable requery of subform when mainform loads

P: n/a
Hi,
I have a form with a subform where the subform uses the value from a
combo box on the main form as a query criteria. I don't want the
subform to update or get data before the user has selected a value in
the combo box because the subquery takes a while to update. Is it
possible to disable the subform to update when the form loads?
Best regards,
Kim

Oct 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Save the main form with source object of the sub form empty, then fill-in
along with the link child and link master and requery after the combo box is
updated.

<ki*****@gmail.comwrote in message
news:11*********************@c28g2000cwb.googlegro ups.com...
Hi,
I have a form with a subform where the subform uses the value from a
combo box on the main form as a query criteria. I don't want the
subform to update or get data before the user has selected a value in
the combo box because the subquery takes a while to update. Is it
possible to disable the subform to update when the form loads?
Best regards,
Kim

Oct 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.