Maintain Selection Order in Multi Select list Box

[AccessGeek]

Hi,


I have a select list box that allows multiple selections using code from here: http://support.microsoft.com/kb/827423.

This is working fine, but I need to list the items in the order they were selected. It appears that this code lists them in the order of the source table. Is there a way for me to maintain the selection order?

I have searched this forum and the Web for an answer but am coming up empty. Any help would be greatly appreciated!

Thanks!

Doug

[weekend00]

you need to save the selected items to somewhere whenever they are being selected or deselected. then you get the order.

[AccessGeek]

Do you know the line of code that will let me do this? Or know of an example somewhere? Thanks!

[pbaldy]

Post 4 (elaborated on a little in 7) is how I add/delete records to a temp table so I know the order in which the items were selected.

https://www.accessforums.net/program...oxes-8172.html

[AccessGeek]

Thanks for your help. I am still stuck. The attached db is a sample of where I am so far. I have a text box that concatenates my selections. This is necessary for an app I am creating that is feeding a web analytics query. These parameters are fed in a string and the selections need to be in order picked by the user. I did try capturing the selections as they occur in a table ("Selected"), but am not sure where to go now. Any suggestions? Has anyone ever tried something like this? Thanks!!!

[pbaldy]

I guess I should have clarified that the delete should only delete the item just deselected, so more like this:

CurrentDb.Execute "Delete * From Selected WHERE Selection = '" & ctl.Column(0) & "'"

The code you have is deleting all previous selections. I would have an autonumber field in that table so you can be sure of the order. Then instead of looping the listbox to set the textbox (which I probably wouldn't bother with, but...) you'd loop a recordset of the table sorted by the autonumber field.

[AccessGeek]

Paul,
I set it up just as you said and it's working like a charm! It's awesome to get something working that you've been stumped by....couldn't have done it without you! Thanks!

[pbaldy]

Excellent, glad to hear it. Welcome to the site by the way!

[AccessGeek]

Thanks! I've been a lurker for awhile and have learned a great deal from this forum. Hopefully I can help someone else at some point.
Thanks again!