It's not clear to me why sorting the data would prevent you from adding a new record, but I seldom work with .ADP Access applications. Perhaps one of the other forum members can shed some light on your situtation. What I would suggest as an alternative is creating an indexed view data source that does the sort in SQL Server before the data is displayed on the form. The support of those in SQL Server 2000 isn't quite as robust as in later versions, but we have used those with success in applications based on SQL Server 2000.