Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sort a listbox
- Thread starter bryn30
- Start date
No but you can sort it with home made buttons
just change the "RowSource"
I just grabbed this from my form change the Table1 and field to match yours
me!List1.recordsource = "SELECT Table1.name, Table1.address, Table1.city, Table1.state
FROM Table1
ORDER BY " & Table1.yourfield & ";"
me!List1.requery
then change the "yourfield" variable to what ever field you want to sort by
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
just change the "RowSource"
I just grabbed this from my form change the Table1 and field to match yours
me!List1.recordsource = "SELECT Table1.name, Table1.address, Table1.city, Table1.state
FROM Table1
ORDER BY " & Table1.yourfield & ";"
me!List1.requery
then change the "yourfield" variable to what ever field you want to sort by
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
- Status
Similar threads
- Locked
- Question
- Locked
- Question