Requerying subform from another subform

[CedarTree]

Hello all.
I have a MAIN form, and a subform listing documents (SF_DOCS) and another subform listing words on that document (SF_WORDS). When I click on a different record on SF_DOCS, I want the SF_WORDS to not just load up using master/child fields, but to go to the top of the datasheet (if you were on the a Doc record previously and on say the 10th row of words, and click on another Doc, the record selector will stay on 10th row in Datasheet, but I want it forced to move to 1st row)
Suggestions please? I've googled with no luck so far. Thanks!

 

[Gasman]

Just issue a requery of that subform.
TBH I thought that was the default behaviour.

As for the title.

Forms: Refer to Form and Subform properties and controls

 

[CedarTree]

It doesn't seem default. I tried setting up a public sub on the SF_WORDS that would would do a me.requery call, but can't seem to get syntax right to call a subroutine from one subform to another?

 

[CedarTree]

Never mind - I got the sub to run me.requery -- to call the sub from one subform to another, I used this: Forms!MainForm.OtherSubForm.Form.subRefreshForm
and subRefreshForm is a public sub that runs me.requery