Forcing a subform requery

D

Dennis

In Access 2002, I have a bound subform that I need to force a requery on from
the parent. How can I do that please?

Thanks a million!
 
K

Ken Snell \(MVP\)

Me.NameOfSubform.Requery

where NameOfSubform is the name of the subform control (the main form's
control that holds the subform object).
 
D

Douglas J. Steele

Shouldn't that be Me.NameOfSubformControl.Requery (or, more correctly,
Me.NameOfSubformControl.Form.Requery)?

Depending on how the form was added as a subform, the name of the subform
control on the parent form may not be the same as the name of the form being
used as the subform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh Listbox in Subform 4
subform based on external SQL won't requery 1
Update Main form from continuous subform 2
Referring to control in the active subform 0
Referring to control on subform 2
Setting a parent form value based on a subform entry 0
requery subform 2
Refresh calling form 7

Top