stay on record after requery

  • Thread starter Thread starter mcourter
  • Start date Start date
M

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.
 
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.
 
Back
Top