>Hi Guys
>
>I have a List Box (RowSourceType=6 ie Fields) with the Table referenced in RowSource Ordered.
>I have two questions here:-
>
>i) When you append a new record to the Table the table new record will fall anywhere depending on its Index position in the Table.
>
>How do I ensure that the highlighted record becomes the newly append record ?
>
>ii) if the index value of the current highlighted record changes in the table, the record moves elsewhere but the highlight usually remains. How can I make the highlight follow the edited record to its new position in the List Index?
>
>Thanks in advance
>
>Fred Matano

Most likely, you will be better served by using grid instead of listbox. You may manipulate listbox too (setting Value property plus Setfocus will move highlight), but grid is a natural choice for the scenario you described.