Keep current record current after sort
Posted on 2009-04-29
I have a continuous subform that is sorted by ProjID. ProjID is bound to a combo box that is used to select a given project number. When the project number is changed, the location of the record in the continuous form shifts to meet the sort criteria (after a requery to populate the rest of the data for the record based on the project ID).
Is there a way to highlight (select) the record that was altered so as to not have to search for the new project in the list?