combo box contents in alphabetical order?

[Dogbert Dilbert]

Hi all,

I feel as if I'm going conpletely mad here. I have a combo box
displaying the contents of a table (all the table holds is a list of
supplier names, plus the ID column). I've put the combo onto a form,
and it returns the selected supplier to a column in a separate table.
My task is simple: I want the items in the combo box to appear in
alphabetical order, but I seem completely unable to achieve this!
I've tried sorting the original table, but this doesn't work. There
doesn't seem to be a command for combo box sorting on forms - is
there?

Any help gratefully received!

TIA

Dogbertd

 

[Ken Snell]

Use a query as the combo box's Row Source. Put an order in that query.

 

[Dogbert Dilbert]

Use a query as the combo box's Row Source. Put an order in that query.

Ken,

Thanks very much - this is a good idea!

Dogbertd