How to fix the glitch in Records in a form in alphabetical order

[Indrit]

Hi all,
This maybe a stupid question but is it possible to sort records so they appear in alphabetical order in a form. Of course the combo box in my form is pulling information from a query, and although i have sorted Ascending it still not giving me the results alphabetically.
Please look at my attachments. The drop down menu in my form is not sorting all codes alphabetically, it starts with LS.01.01.01 and than instead of having the following LS.01.02.01 it bring in the second place another record.



Any help

regards,
Indrit

[ItsMe]

In Design Mode of your form, you can select your ComboBox control and adjust its properties. You can add something like " ORDER BY [MyFieldName];" to the end of the SQL statement in the RowSource property. Just be sure to move the semicolon to the end of the statement ;

[Indrit]

Thank you. It worked!

[ItsMe]

Good News.