List Box Problem

[David Tunstall]

Is there any way you can select two or more values from a
list box and then run a command. (Like holding Ctrl or
Shift to select more than one)

Thanks
David

 

[Jacques]

Hi

If your using Access 2002 in the properties of the Lst
choose in the Others Tab multiselect: Simple

To get the value of the rows use this code:

Dim VarCommande
For Each varCommande In Me.lstCommandes.ItemsSelected
intCommande = Me.lstCommandes.ItemData(varCommande)
Call Update(...)
Next varCommande

I hope this will help

Jack

 

[Guest]

Thanks for that.

Just one more question. Where would I put the code that
you gave me - Dim VarCommande..............

Thanks
David