Soring records

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:

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:

Data1.RecordSet.Sort = "ComapnyName"

Is that how you sort the records or there is some other way to do it?

why don't you try getting the SQL query into a recordset and then setting the source to the recordset? I think it's problem is that the query is not an actual thing that it can link it to.

How do I do that then?

I'm not sure about the exact code (I still have to look up most things!) but it's something like this:

VB Code:

Dim rs as new Recordset
 
rs = "Select * from Customers order by CompanyName Asc"
 
data1.recordsource = rs

again I'm not sure about the exact code

I does not work:(

same error?

"Invalid use of property" error on line:

rs = "Select * from Customers order by CompanyName Asc"