list problem

[brino]

i have a list box that i would ike to select a name and enter what is
selected into another field on the form.i have tried to put the list
box value into the control source of the other field but it just enters

a number instead of the name in the list box.
how cani get it to enter the name that is in the list box ??
thanks

brino

[Ed Robichaud]

It sounds like the first column of your list box is a numeric ID# (it may
have a column width of "0", which is why you don't see it.) Try setting the
control source of your text box to: =Me!myListBox.Column(1)

This will use the value of the second column (numbering starts at 0) which
presumably is the name value you want.
-Ed
"brino" <bd*************@yahoo.com.auwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...

>i have a list box that i would ike to select a name and enter what is
selected into another field on the form.i have tried to put the list
box value into the control source of the other field but it just enters

a number instead of the name in the list box.
how cani get it to enter the name that is in the list box ??
thanks

brino

[Larry Linson]

"brino" wrote

i have a list box that i would ike to select a
name and enter what is selected into another
field on the form.i have tried to put the list
box value into the control source of the other
field but it just enters a number instead of the
name in the list box.

You can bet that Access just doesn't decide to play tricks on you and create
numbers that have nothing, really, to do with your application. Thus, there
may be something you didn't tell us, like:

(1) in the List Box properties, how many Columns are specified
(2) in the List Box properties, what Column Widths are specified

A good guess would be that the List Box was intended to allow the user to
select _whatever_ and is populated with both an identifier/key field, and
the name of the _whatever_, but the width of the identifier/key field is 0
so it doesn't display.

how can i get it to enter the name that is in the
list box ??

Let's clarify what you have, get a "diagnosis," before we start on
"treatment."

Larry Linson
Microsoft Access MVP