multiple select form

[orshims]

hi all

i have made a multiple selection form which selects a 5 digit number from a list in a list box. when i select the numbers (which could be a anything from 1 number 2 twenty numbers) i then press a command button to print out a report based on the numbers i have selected.
my question is when i select the numbers from the list i want the report to print the numbers and the data unique to that number in the order that i have selected them but it prints them in the order the list box is. how do i do this??????????
thanks in advance

 

[vbaInet]

There is no relation between the way you are selecting the items and the ordering set in your report. What you want to achieve is a bit complex. The idea is creating a new column in the table from which your multi select (list box I believe) is getting its data. For any select you set the column to the previous value plus 1. You would also have to handle deselections too. Then in your report you set the ordering to that column. If you can get your head round the idea then great!

 

[HiTechCoach]

Access does not remember/retain the order you selected the items. ATo a list bix, this does not really matter.

If it were me, I would use two list boxes. I would select the item from the one list box and place it int he other list box. This way you can select the order you want them to print in. This is exactly how the Microsoft Find Duplicates Query Wizards handles picking fields.

I find this to be a lot more user friendly and easy to create.

 

[HiTechCoach]

What I was thinking is the you would add a new list box that selects the items into your current list box that is used by the report already. THIS Will allow the current printing function to still work with few if any changes..

Here is an example:

 

[orshims]

thanks guys

i just have to adapt this to suit my needs

thanks again