My Multi-Select Muddle

[Rose]

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?

 

[ElsVanMiert]

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

 

[Rose]

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!

 

[squirrelly]

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?

 

[Rose]

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

 

[squirrelly]

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

 

[Rose]

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

 

[Happy YN]

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