Text box based on list box selection

[HeatherM]

I have a form with a list box showing reports available.
Is there a way I can get a description of the selected
report to appear in a text box when a report is
highlighted?

The list box is unbound but the row source is a
query "qselOptions"
The report descriptions are in a field in the table that
the list box is based on. I have tried setting up a query
with only the report names and desriptions but the text
box wont show anything but "#Name"

 

[Ken Snell]

This URL has info on how to set up this behavior for a textbox and combo
box:

http://www.mvps.org/access/forms/frm0058.htm

With minor tweaking, it should work for a listbox.

 

[HeatherM]

Thank you Ken, it worked like a dream.

I had been wrestling with that all morning!

Thanks again,
Heather

 

[Ken Snell]

You're welcome.

Thank you Ken, it worked like a dream.

I had been wrestling with that all morning!

Thanks again,
Heather