Data Access Pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a data access page and added a dropdown list to the page with
values from a table. How do I get it to sort?
 
Hi! I think you may be able to sort if you use an SQL statement and use the
ORDER BY command. Let me see if I can give you a sample. This would be in
the Row Source property for the cbo box.

SELECT DISTINCTROW [tblSuppliers].[SupplierID],
[tblSuppliers].[SupplierName] FROM tblSuppliers ORDER BY
[tblSuppliers].[SupplierName];
 
Back
Top