Ordering Combo Box in Alphbetical Order

[Harr777]

I can't figure out how to get the items in a drop-down both in alphbatical order. Does anyone now how to do that?
Thanks.

 

[lupins46]

Click into the rowsource property and amend the query by clicking the Build button(...) to the right.

 

[Harr777]

I got that far, but I can't get it to produce the list in alph. order. Went into datasheet view, ordered the column (from a-z) and saved the changes...doesn't work. When I open form it doesn't relfect the changes. Maybe in I change the SQL code itself. Here is the SQL code;

SELECT tblLocations.LocName, tblLocations.RemoveDate
FROM tblLocations
WHERE (((tblLocations.RemoveDate) Is Null));

but I'm not sure how to specify that in the query.

 

[Harr777]

I got it, in the query design view I set the sort property to Ascending. It saved fine.
Thanks.