Set Combobox value programmatically

[rwttm001]

Simple question but driving me a little insane...

How do I set a combobox to a given value in the "ValueMember" field? ie integer value stored in a database, the combobox would display the relevant "DisplayMember" value. I've looked at the findstringexact method but that searches the "DisplayMember" field so is'nt any use.

TIA

 

[SqueakinSweep]

You've done the hard work here....something like this should do the trick

Public Overloads Sub zFindItem(ByVal sText As String)

' Find Item in List using Passed String Value
Dim iFoundPos As Integer
iFoundPos = Me.FindStringExact(sText)
If iFoundPos <> -1 Then Me.SelectedIndex = iFoundPos

End Sub

Sweep
...if it works dont mess with it

 

[chrissie1]

or

combobox1.selectedvalue = myvalue

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting