In response to the first post, I'm pretty sure there isn't a way to stop a Subform from requerying when the Parent Form is Requeryed since requerying causes all controls on the Parent Form to be requeryed and the Subform is a control on the Parent Form.
A couple ways around this is to either Requery specific controls on the Parent Form or by letting the Requery take place on the Subform and then focusing back on the record that you were previously on.
Here is a code snippet that I've used to Move back onto a record after requerying a SubForm:
- Dim lCurrentID As Long
-
lCurrentID = Me![LineItemID]
-
... Do some Stuff ...
-
Me.Requery
-
With Me.RecordsetClone
-
.FindFirst "LineItemID=" & lCurrentID
-
Me.Bookmark = .Bookmark
-
End With
Hope it helps