I can't seem to get my multi-select list box to return the selected values to my table.

I'm starting to get into a bit of a muddle with it. Can anyone please help?

Have a look at the ACCESS ONLINE ENCYCLOPEDIA (www.unsoftwareag.com). In the "forms"-section there is plenty of information about multiselection boxes.

Thanks for the tip. I have been to the site that you mention, but still can't get my multi-select list box to work.

Does anybody have a working sample that they could send me pleeeease!

What do you want the multi-select list box to do? If you want it to act just like a single-select list box, but display multiple selections for each record on the main form (example: multiple products for a vendor) then I may be able to send you an example database with the functionality. It involves several Visual Basic for Applications procedures, which will have to be re-written to work in your application. Do you have experience with VBA?

Yes, I do want to select several values from a list box on a form. I would then like those values to be displayed in the table that sits behind the form.

I know a bit of VBA so I can probably muddle through. I would really appreciate it if you could send me your example.

Many Thanks
Rose

What version are you using? This is in Access2000, and won't work in earlier versions.

This must be my lucky day! I'm using Access 2000.

I have a multilist box which I would like to use to pick up all the members of the list & copy them to a table in that order (very important) so that I can base a query on it. Did that file you were sent help on this sort of thing? If yes would you mind sending it to post@webgem.co.uk
Thanks