Soring records

[abdul]

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

For SQL:

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:

Data1.RecordSet.Sort = "ComapnyName"

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

[shabbs]

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.

[abdul]

How do I do that then?

[shabbs]

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

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

[abdul]

I does not work

[shabbs]

same error?

[abdul]

"Invalid use of property" error on line:

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