Sorting records

[alpesh]

Any body have any idea ...
how to sort record in database through VB

[McKenzie]

1. Add ListBox, Data Contol, CommandButton
2. Attach Data control
3. Set ListBox sorted property to true

code:

Do While Not Data1.Recordset.EOF     List1.AddItem Label1     Data1.Recordset.MoveNext Loop

[Acid]

Well that's what I'd have suggested, if I knew just a little bit more about VB

[Tony]

or if you're accessing your database using DAO method (my personal preference over DB linked elements) you can just have sort=accending/deccending in your SQL statement.

[McKenzie]

you can use DAO and ADO either way. MS is pushing ADO but DAO is still easier to start with.