Listbox filter

[Brightspark98]

Hi,


I have a multi column listbox."data"
Is it possible to filter the contents of column 3 based on multiple values from another listbox?
Column 3 in the data listbox is headed "groups". The filter listbox holds the same info as column 3 in the data listbox. A,B,C,D,E,F etc.
I want to be able to select for example A, D & F from the filter listbox & use it to filter the data listbox on a cmdbutton click.

Hope this makes sense.
Thanks

[ssanfu]

Be aware, "Data" (and "Filter" if you used that as a listbox control name) are reserved words and shouldn't be used as object names.
Also "Data" is not very descriptive. Better names would be "lstData" (list Data) and "lstFilter".

Is it possible? Sure with some VBA programming.
How strong are your VBA skills?


Here is an example.....

[Brightspark98]

Hi Steve,

'Data' & 'Filter' were only used for this message and not in the db.

Your code was excellent, just the job.

Many thanks.

Mark

[ssanfu]

Glad you got it working.




BTW, it is better to use actual object names than to confuse things by using made up names.........