I have a an unbound field that allows me to search for an employee. I would like the drop down list to be alphbetized, however, it doesn't hold the sort. I have completed the following steps.
1. Right clicked on the unbound field
2. Selected property sheet
3. Selected row source (which brings up the query)
4. Query is by EmpID FirstName Last Name
5. Set Last name to sort by alpha
6. Put Last name as the first field
Every time I use the list it is in the original table order. It won't hold the sort or any changes I make within this query. Any ideas?
Thanks in advanced for your help
1. Right clicked on the unbound field
2. Selected property sheet
3. Selected row source (which brings up the query)
4. Query is by EmpID FirstName Last Name
5. Set Last name to sort by alpha
6. Put Last name as the first field
Every time I use the list it is in the original table order. It won't hold the sort or any changes I make within this query. Any ideas?
Thanks in advanced for your help