[AccessD] MULTI SELECT LISTBOX dynamically selecting valuesfromanother listbox

On 4 May 2006 at 12:36, Tom Keatley wrote:

> Hi Stuart....
> 
> Hopefully the last one....
> 
> I have downloaded the code you suggested at tektips and have
> installed it in a module within the database but now get a compile
> error with the message "cant Assign to an array" .... It must be the
> syntax? I must admit this little wall is getting higher for me and I
> am considering finding another way.
> 

Haven't got a copy of A97 handy to check it it.

> For some reason the other code (without split) you did for me is
> giving me a type mismatch error so I made strCurrentValue into a
> string and the code appeared to run giving all the correct numbers and
> iterating through the listbox (in the debug window) but no lines were
> selected....
> 
> can you shed any light?

Looks like your ItemData is not numeric.
Try printing out 
Debug.Print Me!listcon1.ItemData(intI) & " - " & strCurrentValue
in the loop to see what you are actually comparing.

Let us know what you get.