469,946 Members | 1,926 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

Disable requery of subform when mainform loads

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
1 3416
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.

Similar topics

2 posts views Thread by David B | last post: by
1 post views Thread by Johnny Meredith | last post: by
1 post views Thread by Stinky Pete | last post: by
5 posts views Thread by ApexData | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.