Is it possible to store the list from a combo box in a variable???????

[Guest_imported]

Hi,

I'm working on a project and I was wondering if it's possible to store the list from a combo box into a variable so that when the form is hidden or unloaded (it erases the list for some reason) it can be reloaded from a variable in the same order and in list format, not all on one line.

I hope that makes sense.

Cokesplash

 

[vishalmarya]

You can use an array and fill it
or u can use a single variable with some delimiter ,
to identify each value .

 

[papayac]

In the code below the "," is used as the field separator and the command Split is used


Dim S as string
dim T as Variant

'''Load the variable
For i = 0 to (combo1.listcount-2)
s = s + combo1.list(i) + ","
next i
s = s + combo1.list(combo1.listcount-1)

'''Load the combobox
T = split(s,",&quot
for i = 1 to ubound(T)
combo1.additem T(i)
next i