stay on record after requery

[mcourter]

what is the best way to stay on a record in form view after you add a
record to a subform froma click event of a combobox. i need the new
record to show up in the subform after i insert it into the table that
is bound to the subform. when i requery the subform it return the main
form to the first record.

 

[Allen Browne]

You should be able to requery the subform without losing the current record
in the main form, e.g.:
Me.[Sub1].Form.Requery

However, you might find it easier to AddNew to the RecordsetClone of the
subform, so you don't need to Requery.

 

[mcourter]

requery of subform works fine.