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

Requery every subform?

P: n/a
Dim frm As Form
Dim ctrl As Control
Set frm = Forms!frmProductions
For Each ctrl In frm.Controls
If ctrl.ControlType = acSubform Then
ctrl.Requery
End If
Next ctrl

as a way of requerying every subform (in this case as an after insert)

What does anybody think?

Yours, Mike MacSween
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Mike MacSween wrote:
Dim frm As Form
Dim ctrl As Control
Set frm = Forms!frmProductions
For Each ctrl In frm.Controls
If ctrl.ControlType = acSubform Then
ctrl.Requery
End If
Next ctrl

as a way of requerying every subform (in this case as an after insert)

What does anybody think?

Yours, Mike MacSween

Doesnt' me.recalc do that? (and more, indeed)

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #2

P: n/a
Well there you go. I never know about recalc. Thanks very much. Yes, it
seems to do exactly what I want.

Cheers, Mike

"Bas Cost Budde" <ba*@heuveltop.org> wrote in message
news:c0**********@news2.solcon.nl...
Mike MacSween wrote:
Dim frm As Form
Dim ctrl As Control
Set frm = Forms!frmProductions
For Each ctrl In frm.Controls
If ctrl.ControlType = acSubform Then
ctrl.Requery
End If
Next ctrl

as a way of requerying every subform (in this case as an after insert)

What does anybody think?

Yours, Mike MacSween

Doesnt' me.recalc do that? (and more, indeed)

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.