>I have a Grid in a form that allows users to add rows. To add a new row, my code fires an append blank. Unfortunately, all new records appear at the bottom of the grid and not index order. Is there a way to reorder the Grid on the fly?
Hi Andy,
Provided the recordsource of the grid that you are appending a record to is ordered, after the append and update of the data, try refreshing the grid by calling its Refresh() method. I think might order the records properly. The problem might lie in the APPEND. I'd look at using INSERT-SQL, as it will definately insert the record into the correct order placement.
Phil