I have a form that lists numerous records of past due loans. I created a form to automate the adjustments. The form has a button that is clicked to duplicate the reverse of the record... Basically a negative entry for the same amount as the original record. The form always goes to the end once the record is duplicated so I do a docmd.showallRecords. Is there a way to setFocus on the duplicated file that is now been sorted back into the long list of loans?
Thanks
Thanks