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

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

"Alan" <(E-Mail Removed)> wrote in message
news:8105F842-6325-4BFA-B4FE-(E-Mail Removed)...
> 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

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

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


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jeanette Cunningham" wrote:

> 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
>
> "Alan" <(E-Mail Removed)> wrote in message
> news:8105F842-6325-4BFA-B4FE-(E-Mail Removed)...
> > 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
>
>
> .
>