MultiSelect values in ListBox, Find Values in Record, Click Cmd Button

[infinitx]

Hi,

I have a form which has a listbox that lists all Item ID's currently in the database. The ListBox's Multi-Select is set to Simple. Lets say the user chooses the following Item IDs: 3, 258, and 396. After the user clicks a command button, I want the program to find the records that have those Item ID's and I want them to be displayed in a Continious Form fashion. After that I have a command button that adds all of them to the test. How can a do a loop so that the command button code gets run 3 times in this case?

Thank you!

 

[Pat Hartman]

Take a look at my multi-select listbox example. It shows how to loop through the selected items collection and append rows to a table.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54924