Hello everyone,

I require a little bit of help please if possible.

I have 2 boxes on my form, one is Drive and the other is directory. (both have row source type of Value List)

In the driver box, it looks up the drives on my PC (A:\, C:\ etc)

If I then choose c:\, the Directory box changes to show the directories within that drive. e.g. My Documents, Program Files etc

The problem I have though is that the directory box doesn't sort in alphabetical order.

Is there any way I can do this ?

Thanks in advance.

J.

If it is a listbox then go to the rowsource property, click on the ... icon and a query should show. You can then sort by the correct field