sure this is easy

[tcommis]

I'm sure this is easy but as ussual can't get it to work

I have a pull down list box in a form - List is off a table
I've sorted the table (asending) but canot get the list box to do the same. I'm already to slap the forehead and go "duh" so don't hesitate to show me my error

Thanks

 

[dcx693]

Change the rowsource type of the listbox to "Table/Query" and change the rowsource itself but clicking the three dot thingee to the right of the property setting. Then select the field that feeds into it as if you were making a query and sort the field there.

 

[tcommis]

THANKS! DCX

Duh -- Wack!