Combo Box List Order

[Bruister via AccessMonster.com]

I have created a Combo Box that Auto Fills adjacent fields with data from a
table and was slapping myself on the back until I found that my Combo Box
which I had previously set to list items in ascending order is now all over
the place after I add the code to carry out the auto fill function. If I go
back to the stand alone CB I get my nicely ordered list back! How can I have
both the ascending list and auto fill capability?

 

[Douglas J. Steele]

Perhaps you're using the terms differently than how I do, but I can't see
any reason why auto filling adjacent fields would impact what's displayed in
the combo box.

What's the RowSource of your combo box? If you're pulling data from a table,
make sure to use a query with an appropriate ORDER BY clause rather than the
table itself.