Sorting a database within VB6

I have a database that holds names and addresses, there are duplicates in that list so the primary key (made in ms access) is the auto number. I need to get vb to scroll through the list in alpha order when the user presses the data control arrows. I know this is a repeat but I still am unable to sort it... Thanks

[cath]

You can sort the table in access. Or if that isn't an option, are you using an SQL statement to get the recordset? If you are you can say "select * from tablename order by fieldname" Mail again if this doesn't solve it.
Cath