Requery subform without losing place (1 Viewer)

[evanscamman]

I appear to have accidentally discovered something that may useful if anybody else can recreate it.

Requerying a subform by referring to the control on the parent form appears to requery without losing the current record or the selected control on the subform.

myForm!mySubForm.Requery - doesn't lose place
myform!mySubform.Form.Requery - does lose place.

Can anyone else confirm this behaviour?
Up until now I have had to use bookmarks, etc.. to return to place after a refresh.

Thank you,
Evan

 

[HiTechCoach]

Your code says requery. In you statement you say refresh. Did you mean requery?

 

[evanscamman]

Yes - i meant requery.