Form Combo Box

[Rosemary]

In Access 2007, I have a look-up column in a table that has ID, Last Name,
First Name (from another table). I built a form using this table. In the
form, I want to display the look-up combo box column as "display only" with
no border. However, when I change the locked property to 'Yes', it displays a
down arrow which looks really strange. So, I then changed the combo box into
a text box. Now, it displayed the ID instead of the Last Name. How can I have
the Last Name displayed without a border and no down arrow?

Thanks so much for your help.

 

[Klatuu]

In a combo box you can't.
If you want to use a text box to show the last name, you can populate it
from the After Update event of the combo using the column collection of the
combo:

Me.MyTextBox = Me.MyCombo.Column(2)

Will put the value of the third column of the selected row in the text box.
The column index is zero based.

 

[Jim Bunton]

I guess I'm pretty confused by your question - which is probably why you
arent getting much response - suggest you think about it a bit more then try
to clairfy what is is you want and answer to.

Hope this helps!