adodc sort

I have a ado data control bound to a table. The table is sorted and indexed on its primary key which is numbered sequentially. But when browsing through added records, I find the sequence displayed randomly (as far as I can tell).

Has anyone faced this dilemma before? I wonder if the data control has a sort method itself?

The recordsource property of your ado control has a spot where you can place some SQL code for your data to be displayed in some sort of orderly fashion.

Example SQL:

SELECT * FROM table1 ORDER BY date DESC

"table1" is the name of your table
"date" is a field in your table
"DESC" is desending order

you should be able to cut and paste the above code and substitute your table name
and field name

[Clunietp]

There is a sort property of the data control without having the requery the server (I believe)

USAGE:

Adodc1.Recordset.Sort = "FieldName [ASC/DESC]"