hello,

I have a form with a series of comboboxes. I would like to pass the values of the comboboxes to an array. I'll check if there are duplicates in the database. for the input which are not duplicates I'll store the values in the database.

i would have 2 questions:

- is it a good strategy?
- how do i pass the values of the comboboxes into the array??

i have a problem with the "i" in the loop...

[vba]
Dim aSecurities()
ReDim aSecurities(1 To 6, 4)
For i = 1 To 6
aSecurities(i, 1) = Sectype & i & .value
aSecurities(i, 2) = Zone & i &. value
aSecurities(i, 3) = Valoren & i & .value
aSecurities(i, 4) = Ticker & i & .value
Next i

[/vba]

i've been trying using double quotes and another few tricks but it didnt work...

does anyone have an idea on how to deal with this please?
thanks!