show data alphabeticly in combo box

[ranj.bassi]

Hi Was wondering if someone can guide me in the right direction.
this is my first post.

I have a form with a combo box listing 900 pupils but the list is in no particular order. How can I sort the surnames in alphabetical order and for those changes to reflect on my form.

The problem I am having is I can sort it out in alphabetic order but the changes dont reflect onto the main form.

Does anyone have any suggestions.

Kind Regards

Ranj

 

[RuralGuy]

The Form can have a Record Source and the Combo Box has a Row Source. Press the builder "..." next to each item and sort the column you wish in the Query Builder.

 

[ranj.bassi]

Thanks for the reply. I sure I mite be dumb here but where do i find the query builder?

 

[holiday_intern]

DesignView -> ComboBox Properties -> Data -> RowSource

here you add ORDER BY tablename.surname to your Query

 

[ranj.bassi]

thanks for that. You helped me out a lot. cheers again.