Populate a list box

[See29596]

Hi

I am trying to do the following with visual web developer 2010 (Visual Basic) :
on the web page i have a combobox that has data from an access table (a category table.)
when I select a category from the combobox I want the data from another table (items) that have the same category code as the selected category
to show in a listbox on the same page.

I did get the combobox to work and I can get the category code and store it in a variable.
I dont know how to select the correct data and store it in the listbox.
Can anyone please show me how to do this ?

[EINSTEIN_007]

You can try to do this in a very good way by building a filter expression, check the below code for example:

Private Sub Combo1_AfterUpdate()
'FILTER BY SELECTED CUSTOMER_ID
Dim S As String
Dim V As String
V = Combo1.Text 'updated from the user's selection
S = "[CUSTOMER_ID]=" & "'" & V & "'" ' The bound field on your Invoice form
Me.Filter = S
Me.FilterOn = True
End Sub