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!
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!