subform behavior

[smk23]

I have a subform with code on the AfterUpdate event on one of the subform
controls that prompts a requery on a pull-down on the Parent form:

Me.Parent.cboList.Requery

The subform and the parent cboList use the same underlying table, but have
separate queries as recordsources.
When this executes, the subform is also requeried which is irritating,
because now the record being edited moves and the user has to chase it down.

The point of the code is to refresh the cboList when edits are made via the
subform. Is there a way to resolve this (prevent the subform requery)?

 

[George Nicholson]

store the key value of the current record before you do the requery and then
go back to that record via code after the requery.