Having trouble with the access 2000 listbox . . .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm familiar with using listboxes in VB6 but I'm currently using VBA in
access 2000.
Can someone please show me how to take the selected text from a row in a
listbox and simply display the text in a textbox field ? Sounds simple enough
but I just can't seam to get it.

p.s. The listbox is populated with a field from a table using the rowsource
property.

Thank you
 
If you are not using a Multi Select list box, wouldn't a combo with a
rowsource type of field not be easier to deal with? It would then be
Me.txtBox = Me.cboBox

Using a list box takes a little more, and for example purposes, I will
assume a single select list box:

Me.txtBox = Me.lstBox.ItemData(Me.lstBox.ItemsSelected(0))
 
I haven't experienced that. I seldom use List boxes or Combo boxes as bould
controls. I don't know what the difference may be.
 
Back
Top