Re: getting single selected value from listbox

Please re-read my previous response.

A listbox with, say, 4 fields displayed can have 17 fields, with a width of
"0" for all but 4 of them. Typically, the first field is used to hold the
rowID from the underlying source table/query, but its width is set to 0 so
it doesn't show/confuse the user. Typically, the first visible field is the
one that contains the user-friendly text.

You haven't indicated which you are trying to retrieve.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"smarty" <smarty@xxxxxxxxxxxxx> wrote in message
news:5096D1B0-93FE-4BB3-8C7C-B72B2E471B1A@xxxxxxxxxxxxxxxx
I have a form form1 which lauches another popup form form2. form2 has a
number of listboxes with thier row source bound to stored procedures to
populate them. Once the user has selected the company (listbox1),
location
(listbox2) and contact (listbox3) I wish to return the selected values to
textboxes in form1.

I can't seem to find the listbox method that gives me the selected value
from the listbox. I am not allowing multiple value selection so should
only
need to return a single value.

"Jeff Boyce" wrote:

Are you trying to retrieve the bound value of the selected row in the
listbox, or the displayed value (these don't have to be the same, and
seldom
are)?

You don't provide much to go on ... what have you been trying? What
happens
(?error message, Access quits, ???)?

More specific information will lead to more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"smarty" <smarty@xxxxxxxxxxxxx> wrote in message
news:F8B87DB2-5C71-4821-99A0-29999ED526FC@xxxxxxxxxxxxxxxx
Hi,

I have been trying to get the selected value returned from a listbox.
Any
idea how to do it?





.

Loading