Hi -

I have a combo box that is populated using an ADODB connection. My problem
is that i am able to view the list once i click on the drop button arrow, but
if a select a value, it doesn't appear in my combo box. I have tried to use
the listindex property but i am still unable to view the value that i select.
Any ideas would be greatly appreciated.

Thanks.

how do you populate the combo box? do you use the drop button event and
somewhere in your code clear the combobox before you populate it? if you use
the drop down button event, i've had the same problem.

if i remember correctly, i've been able to store the combobox value to a
variable before i clear the combobox, then set the value back to what it was
before.

For example:

SelectedItem = Me.FileList.Value
Me.FileList.Clear
Me.FileList.Value = SelectedItem

good luck!


"LHaro" wrote:

Hi -

I have a combo box that is populated using an ADODB connection. My problem
is that i am able to view the list once i click on the drop button arrow, but
if a select a value, it doesn't appear in my combo box. I have tried to use
the listindex property but i am still unable to view the value that i select.
Any ideas would be greatly appreciated.

Thanks.

sorry i missed the ADODB connection is used to populate the combobox. i'm
not very familiar with this.


"LHaro" wrote:

Hi -

I have a combo box that is populated using an ADODB connection. My problem
is that i am able to view the list once i click on the drop button arrow, but
if a select a value, it doesn't appear in my combo box. I have tried to use
the listindex property but i am still unable to view the value that i select.
Any ideas would be greatly appreciated.

Thanks.