Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .

 

This sample illustrates how to make items in an unbound listbox move up and down in the list. Although it is not bound, it never the less requires a table as a Row Source. This table MUST have an editable field (not an autonumber) that indicates the order that the records should show. The process simply exchanges the values of two of the ordering fields and requeries the listbox.