Data Access Pages

[Chris]

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?

 

[Rob M.]

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];