sorting txtboxes

[khanh]

Hello,
We have an application that retrieved information from database and populate text boxes,(for example txtId, txtLastName, txtFirstName, txtDepartment...) Users want a button next to each text box, so they able to sort by ID, LastName Firstname or Department...
1.How do you set sort to txtbox?
2.We also have a txtbox for use as comment. Some users want to switch the txtbox into column such as excels, when needed. How can I achieve this?

Please help, thanks in advance.

Khanh

 

[Kendel]

Set a Sort command next to each text box. When user click on this command, the sql statement is executed:

"Select * from yourtable order by '" & txtId.txt & "'"