Sorting records?

Hello

Is there any way that you can sort the records in ado data control? I have the records sorted in ascending order in the database but when I scroll the records on my form they are in descending order.

Any suggestions?

Change your SQL statement. Not that familar with ado, but here is a sample SQL statement.
"Select * from Table order by Name"

you forgot the sort order...Dsc for decending.

"Select * from Table order by Name Asc"

Thank you CthuluDragon, and HeSaidJoe both of your suggestions worked. HeSaidJoe just add a little secruity to the sql statement.

Thanks again!!

Wasn't sure what the default was. Since both work, the default is ASC...so CthulhuDragon, my apologies...you didn't forget..you knew better....I should have known it wouldn't be Dsc...in hind sight, that's as bad as thinking right to left as the default in reading.

Later.