I have a form call frmdetails which displays all of the people in a table in a list box. I have a form that adds new people to the table. It only adds first, middle & surname. Once the record is added, i then clear the original list on frmdetails then reapply the list with the new recorded, sorted by surname.
How do i get the list box to automatically select and go to the record i have just added?