hi i want to sort a recordset when a form loads
for example
adodc1.recordset.sort ????
???? = i want to sort vacancy_id feild to a-z
Printable View
hi i want to sort a recordset when a form loads
for example
adodc1.recordset.sort ????
???? = i want to sort vacancy_id feild to a-z
Whats the problem here ... ???Quote:
Originally posted by renos
hi i want to sort a recordset when a form loads
for example
adodc1.recordset.sort ????
???? = i want to sort vacancy_id feild to a-z
Adodc1.Recordset.Sort = "vacancy_id Asc" or
Adodc1.Recordset.Sort = "vacancy_id Desc"
Sort the data in your SQL - it'll be quicker.
SELECT * FROM Table ORDER BY Vacancy_ID ASC