Data Access Pages

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?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Help With MS Access 4
Snowflake to SSIS 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Another Data Access Page Question 2
Unbound Data Entry Form 5
Data Access Page Design 3
Fillable Data Access Pages 2

Top