Alphabetical sorting?

[Hellfire]

Hi all,

I have a combo-box with a number of values in it. The values in the combo-box is stored in a table. I have a form that can be used to add new values to the table, this will then be available in the combo-box as well.

However, I need the values in the combo-box to be displayed in alphabetical order. I know they wouldn't be in Alphabetical order on in the table, since the last record is just added to the "bottom" of the list. BUT, I need them to display correctly on my form.

HOW do I do that?

Thanks

 

[ColinEssex]

Go into the properties of the comboBox and put curser in "RowSource", there's a little grey box with 3 dots on it to the right ...

Click on this and that gets you the query grid of the combo. Do the sort there as per a normal query.

Col