Sorting Table with Macro

[msinsabaugh]

Please forgive me if this is a) already covered in this forum or b) belongs in another forum. I can’t seem to find it here so I hope I’m not wasting people’s time.

I have a form that has a drop down menu populated by a table.

The form has a button to bring up another form that allows the user to add/edit the table that populates the drop down menu.

The key value in the table for the drop down menu is text and once the user closes the form, I want the TABLE that contains the drop down items to sort on the key field so that item 1000 at the top of the table is followed by 1000A that was ended at the end of the table.

I saw another post that says I shouldn’t bind a table to a form but in my ignorance I did so. I might be able to go back and recreate the form basing it on a query but I would like to avoid spending that time.

Does anybody have any ideas??

 

[Rob.Mills]

You need to create a query on that table with a sort order. Then use the query as the rowsource for the box. Tables don't have sort properties. You can sort them if you open them directly as a datasheet but that's the only time.