More than one ControlSource in a listbox

[Guest]

Hello,

The setup:
Access 2000. I have listbox on a form returns 6 fields from a table. When a
user clicks an item in the listbox, the form receives the field value listed
in the ControlSource property. The BoundColumn setting controls the field
that is passed to the form.

The problem:
How can I get an additional field from the listbox to populate a 2nd control
(e.g. textbox) on the form? I need minimum 2 fields from the user's selection
to pass to the form so I can perform some automation later. Right now I can
only retrieve one....

Any suggestions will be helpful!

 

[Ken Snell [MVP]]

See this article at The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm

It's written for a combo box, but you can easily use the same concept with a
list box.

 

[Guest]

Thanks very much. That did the trick!

-AA

See this article at The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm

It's written for a combo box, but you can easily use the same concept with a
list box.