Sort record

I have a database through Access that holds name's and addresses. There are duplicate names so the primary key is the generic counter. My question is how can i sort that database from VB6 to where all the names are in order and when using the data controlit scrolls in alphabetical order... Thanks..

[vikram.k]

Hi Wookie,

For example, your table is address_detail and fields are name,state,... Then you have to declare the following statement in form_load even if you are using Data Control.

Private Sub Form_Load()

Data1.RecordSource = "select * from address_detail order by name"

End Sub

Now you will get what you have expected at the time of execution.

Bye!.

Thanks!!!

Thanks!!!
So what do i put on the right of the =
data1.recordsource = State from address_detail order by name. ???