VB6 get a value selected in a combobox

Question

I'm building a combobox with the following:

Select 1 or 2 seats: 1 2

And I need to show 1 or 2 as selected depending on the result of a query.

How can I do that?

I have done so far:

SQL = " SELECT numberOfSeats FROM mytable " SQL = SQL & " WHERE userID ='" SQL = SQL & txtuserID.Text & "'" Set auxRes = UAN.OpenResultset(SQL, rdOpenDynamic, rdConcurValues, 0) cmbNumberOfSeats.Clear cmbNumberOfSeats.AddItem "Select 1 or 2 seats" cmbNumberOfSeats.AddItem "1" cmbNumberOfSeats.AddItem "2"

Thanks!!

See this? stackoverflow.com/questions/18422210/…

CMaster
– CMaster

2015-02-19 16:31:03 +00:00
Commented Feb 19, 2015 at 16:31 — CMaster
– CMaster, Commented Feb 19, 2015 at 16:31

xxbbcc · Accepted Answer · 2015-02-19 16:18:55Z

You can use the ListIndex property of the ComboBox control to get / set the index of the selected item. You use it like so:

Dim nSelectedIndex As Long nSelectedIndex = cmbNumberOfSeats.ListIndex If (nSelectedIndex < 0) Then 'No selected item in the combo box Else 'There's a selected item, handle it End If

To set the selected item:

cmbNumberOfSeats.ListIndex = nNewSelectedIndex

The index of the first item is 0; when there's no selection, ListIndex returns -1.

Collectives™ on Stack Overflow

VB6 get a value selected in a combobox

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related