ComboBox - Changing the selected item

[Michael Turner]

Hi I am having a problem with a combobox the values are generated from a
recordset, I need to beable to change the selected item to the value
specified in a configuration file, I have stored the value as a varible. I
am using the code below but it isn't working any ideas am I using the right
method.


combobox1.selecteditem = getcolvalue(0)

Any help appreciated.

Mike.

 

[Shiva]

Hi,
Does the value returned by getcolvalue(0) exist in the combobox list? If it
doesn't, then you will not see the selected item changing.


Hi I am having a problem with a combobox the values are generated from a
recordset, I need to beable to change the selected item to the value
specified in a configuration file, I have stored the value as a varible. I
am using the code below but it isn't working any ideas am I using the right
method.


combobox1.selecteditem = getcolvalue(0)

Any help appreciated.

Mike.

 

[Michael Turner]

Hi

Yest it does the value was created by the listbox and saved to the config.

Mike.

 

[Shiva]

Hi,
Just to try an alternative way, have the following instead of using
SelectedText:

combobox1.SelectedIndex = combobox1.FindStringExact(getcolvalue(0))

If the return value of "combobox1.FindStringExact(getcolvalue(0))" is -1
then getcolvalue(0) is returning something that doesn't exist in the combo
list.

Hi

Yest it does the value was created by the listbox and saved to the config.

Mike.

 

[Michael Turner]

Hi Shiva

Yes that worked, after a bit of playing about I think the first method was
not working because of the way I was pulling the information from the
database, the selectitem method was not returning a string value(well thats
what it said when I tried writing the selecteditem to the debug window)!.

Thanks for all your help.

Mike.