I am trying to sort the records in table by using SQL statement or the "recordset.sort" property of data control.

For SQL:

VB Code:
  1. Data1.RecordSource = "Select * from Customers order by CompanyName Asc"
It gives me an error message saying "jet databse engine could not find the object 'select *...'

For data control:

VB Code:
  1. Data1.RecordSet.Sort = "ComapnyName"
Is that how you sort the records or there is some other way to do it?