Help: out of order

[Rican]

Hello everyone... I'm creating a type of help desk form in order to keep track of calls, etc. I have the form but when I add a combo box to it, the contents of the box are not sorted. If I look in the table where the values are coming from, they are sorted aphabetically. Why don't they show up sorted in the form and how can I fix it? TIA

PS: If you really want to help me, look at my other posting on the Forms forum about autofill options...

 

[ray705]

Go to the Form's properties. On the Data tab fill in the Order By with the sort field ie. Employees.LastName

 

[Rican]

I'll try that. Thanks.

 

[Pat Hartman]

When you open a table in datasheet view it appears sorted because behind the scenes, Access creates a query and includes an order by clause that orders the recordset by the table's primary key. So, what you are actually seeing is the result of a query and has no relation to how the records are physically stored or how they would have been presented had the query not included an order by clause.

So, the bottom line is - the only way to create a recordset with a predictable sequence is to use a query with an order by clause. Create such a query and use it as the rowsource for the combo.

BTW, if you want to refer people to other posts, don't make them search for them, post a link.

 

[Rican]

Thanks Pat... I will probably have to do the query thing that you mention because the properties thing didn't work.
I will try and use links from now on...