re-ordering list

T

Terry

Hi,

I am looking for some advice on designing a form.

Access 2000

I want to populate a form with user selected records from
another form. I can do this part.

However I want the user to be able to re-order the records
in the newley populated form by highlighting a record and
either dragging it up or down or highlighting a record and
clicking an up or down arrow to shift it's position in the
list. I anticipate the number of selected records will be
from 3 to 200 records. A bit like you can re-order
the "Tab Order" or the report "grouping". I wish to
maintain the final order and export the results so I asume
I will need to number the records and renumber as the
order is changed. I am hoping there is a relatively easy
way to do this. Any suggestions or examples would be
appreciated.

Thanks,

Terry
 
Top