Retrieve items from list box

[TryingMyBest]

Hi Folks,

I have a small database containing a table of questions and a table of teams who would be asked the questions. There's a third table to link them.

I have a form where the user can select a number of teams to create a word document containing all of the questions (sorted by team). There is a list box with all of the teams and a list box to contain the selected teams.

How do I retrieve the data from the list box with the selected teams so that I can transfer them to word and sort them?

I know how to transfer data to word and I think I know how to sort that data when in word but I cannot for the life of me figure out how to obtain the list items into a state where I can transfer them to word in the first place.

Any pointers would be great.

I'm using Access 2000 with Windows XP

Thanks
Jo

 

[RuralGuy]

See if there isn't something at this link that can help:
http://www.fontstuff.com/access/acctut11.htm