Open record from List box

  • Thread starter Thread starter kharpe
  • Start date Start date
K

kharpe

I have a form with two multi-select list box that I would like to use to open
a specific record from. I have set up the list boxes so that i can move
items from one to the other, multiselection is so that I can move multiple
items at a time. Is there a way that I can use the ondoubleclick property
to open the individual item that I have double clicked on. My trouble is
with getting the primary key for the item out of the list box.
 
I'd just use the Click event, or you turn it on, then turn it off. Have a
look at this code:

With Me!lstElevation
If .MultiSelect = 0 Then
Me!txtSelected = .Value
Else
For Each varItem In .ItemsSelected
strList = strList & .Column(0, varItem) & ","
Next varItem
If strList <> "" Then
strList = Left$(strList, Len(strList) - 1)
End If
Me.txtSelected = strList
End If

End With

You can create a textbox (txtSelected) which is filled by strList, then use
that in an IN Clause in a SQL statement for a form's recordsource. The first
column of the list box has its columnwidth property set to 0" but it is the
bound value of the listbox.
 
Back
Top