>I have an adjustable list box which displays the records in the table the user is currently working on. When they add a new record, the record displays at the bottom of the list, rather than in the correct order. If I close the screen, and re-open it, the record displays in the correct order.
>Is there something I need to do that puts the record in the correct order in the adjustable list box?
>
>Thanks
>
>Steve Baum
>MicroSystems

If you are updating your table using a View and sending SQL updates, and if you set the cWorkArea property in the adjustable listbox to the View, issuing a THIS.Requery() in the Datamanager's Afterupdate method will pop the new record into the proper order in the adjustable listbox. It will also set the record pointer to the first record in the View. So you will have to use one of the datamanagers navigational methods to move the pointer to the record that was just entered or anywhere else that you may want it to end up.

As far as trying to get the adjustable listbox to display a new record in the proper location when working directly with the table, I have not figured this one out either.

What are your RowSource and RowSourceType settings for the contained ListNavigator control?

Chuck