Having trouble with the access 2000 listbox . . .

[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

 

[Guest]

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))

 

[Guest]

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.

 

[Guest]

Okay, Thank you for your help anyway. At least now I know the proper syntax.

Thanks
Shawn

 

[Guest]

Sorry I couldn't completely resolve it, but at least you're on the right track.