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