Hi,
I have a extended combo box(mybox) that gets its values from a Table.
Is there anyway to assign for the on click event procedure the zero
based selected array to another array that's public?
I was trying to do this:
Public myarray(100) as (boolean or integer) 'defined in a start up
form

then I want to say myarray = Me!mebox.selected
but that does not work.

Thanks in advance

You need a simple loop

Dim i as integer
Dim j as variant
i = 0
for each j in mebox.selected
i = i + 1
myarray(j) = i
Next j

j has to be a variant, not an integer.

Hope this helps

"Enterprise" <vaylg (AT) hotmail (DOT) com> wrote