Changing combo to list box for multi select values

[Alan]

Hi all, can anyone help

I have a variable listbox, which when i click another list box it fills the
first listbox with value relating to my other list box eg

when i click customer in one list box it fills the another with all customer
name,
when i click sales person it fills it with sales people names

now what i need it to be able to select multi values in this listbox,
it is not bound to any columns as it a variable, how do i get it to select
multi value and where would i place this in my code

for example would it be after update to that list box

Thanks in advance

by the way my listbox is called
lstReportFilter

 

[Jeanette Cunningham]

Here are 2 sample databases about using multi select listboxes.
http://www.rogersaccesslibrary.com/forum/topic316.html

http://www.rogersaccesslibrary.com/forum/topic315.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[ryguy7272]

Great example here:
http://www.fontstuff.com/access/acctut18.htm

Download the sample DB at the bottom of the page:
AccessAndSQL5_2000.zip [122KB]