List Box

[Joe]

I have a lookup list with two colums. Colum 1 has the
persons initials and colum 2 has the persons name. I have
a form with a lookup box to select the persons initials.
This works fine. What I am trying to do is have another
field on the form that will display the persons name when
his initials are selected. Can this be done? If so, how?

TIA.

Joe

 

[fredg]

I have a lookup list with two colums. Colum 1 has the
persons initials and colum 2 has the persons name. I have
a form with a lookup box to select the persons initials.
This works fine. What I am trying to do is have another
field on the form that will display the persons name when
his initials are selected. Can this be done? If so, how?

TIA.

Joe

Joe,
Add an unbound control gto the form.
Set it's control source to:
= Me!ComboBoxName.Column(1)

Note: You wrote that the combo box has 2 columns. Combo Boxes are Zero
based, so column(1) is the 2nd column.

 

[Joe]

Thanks, Fred. Actually I woprtte that I have a lookup
list with two colums. The lookup box is set to select the
entries in colum 1 of the lookup list. What I want is a
field in the form that will automatically display the
data in the second colum, persons name, when I select the
initials from the first colums using the lookup box.

Sorry if I wasn't clear on this before.

Joe