Listbox on a form - how to detect which item is highlighted?

[TheWennerWoman]

I have a form with a combibox, a listbox and a textbox.

The user selects a category from the combibox and I have some logic that populates the listbox with subcategories relevant to the category.

The user then highlights one of the items in the listbox and enters a new value for it in the textbox. This drives a SQL query that will update the record in a database. Except I can't manage to get the code to detect which item in the listbox has been selected. Consequently, my SQL UPDATE statement looks like this

UPDATE Reporting_Test SET Subcategory = 'ValueFromTextBoxHere' WHERE Category = 'ValueFromCombiBoxHere' AND Subcategory = 'ValueFromListBoxHere'

where the last bit of the code has nothing in......so it's not picking up the highlighted item.

Many thanks.

 

[Dan_W]

Except I can't manage to get the code to detect which item in the listbox has been selected.

What code have you tried? Because if it's just a default / single-column listbox, you should be able to get the selected item by using the Value property = ListBox1.Value

 

[TheWennerWoman]

What code have you tried? Because if it's just a default / single-column listbox, you should be able to get the selected item by using the Value property = ListBox1.Value

Ok, my bad.

I had a variation of this commented out

For x = 0 To ListBox1.ListCount - 1

      If ListBox1.Selected(x) = True Then
         MsgBox ListBox1.List(x)
      End If

   Next x

Apologies, all working now.