Newbie: Problem accessing Listbox selection

Z

Zach Williams

I have a listbox (Lst1stStatus) for my tblStatus table. I make a
selection by clicking the arrow button on the listbox and then click a
Filter button. In the Filter Click event, I have the following code
which never produces a selection:

Dim varIndex As Variant
Dim strStatus As String
Dim lstStatus As String

For Each varIndex In Me.Lst1stStatus.ItemsSelected
lstStatus = Me.Lst1stStatus.ItemData(varIndex)
Next varIndex


For the listbox,
ControlSource = =tblStatus!Status
RowSourceType = Table/Query
RowSource = tblStatus

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top