Resorting Combo Box In Alphabetical Order

[DigitalAdrenaline]

Hi, I'm having trouble resorting a combo box linked to a table to appear in alphabetical order.

I click a cmdButton op open a form containing a subform table of my data. I add the data, save and requery the table to appear in alphabetical order.
I refresh my main form with the combo box, and when i select the drop-down list, it's not in alphabetical order. Something is disconnected. I'm checking all the source linking and nothing appears to be out of order. Just wondering what I've missed. Cheers..

[CJ_London]

two questions:

Is the field in the table a lookup?
what is the rowsource to your combo

[DigitalAdrenaline]

Hi Ajax, no, there's no lookup.

frmOne is RecordSource linked to tblOne. To add new data, a cmdButton on frmOne opens frmTwo which has a subform sourced to Table.tbleOne.
When I add new data, I click a cmdButton that saves, GoesToNewRecord, and Requeries the table into alphabetical order. No problem so far.
I close frmTwo, back to frmOne and click a refresh button. This step is supposed to reorder the records (combo boxes) in frmOne alphabetically. But alas, it doesn't.

Now I'm perplexed.

[John_G]

This step is supposed to reorder the records (combo boxes) in frmOne alphabetically. But alas, it doesn't.

How are you doing that? The ordering of the records in your forms and subforms, and the ordering of the rows in a combo box are independent operations, i.e. resorting a form will not automatically resort the combo box. You need to explicitly requery the combo. If you want to have the rows in the combo sorted in a specific order, you should include an ORDER BY in the combo's row source.

[DigitalAdrenaline]

Thanks John, that was the missing link, ORDER BY in the Row Source . The combo box is now in Alphabetical order. I'm building my project off the back of Udemy, you Tube and the Access 12010 Bible. I've obviously misinterpreted the REQUERY function from the video I was watching. I spent hours last night trying to solve this issue. Many thank. Cheers.