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?