show 2 cols in dropdown?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

r - 14 Oct 2005 21:38 GMT

I have a dropdown on a form and can't seem to figure out how to display the
value of BOTH columns once the selection is made instead of just displaying
the bound value. ?? I know it can be done, and I used to do it eons ago,
but I can't figure it out! Help!

So, I have a dropdown that, when dropped down, displays:

ID NAME

However, once the user makes a selection, only the ID displays in the field.

Thanks.

Reply to this Message

Steve Schapel - 14 Oct 2005 21:52 GMT

R,

If you only want the Name to show on the form, even though the ID is the
boind field, you can set the Column Widths property of the Combobox so
that the ID column is hidden, i.e. set it to 0;x (where x is the width
required to display the Name column.

If the requirement is to see both the ID and the Name on the form, there
are several approaches that can be taken to this. They are explained in
this article...
http://accesstips.datamanagementsolutions.biz/lookup.htm

Signature

Steve Schapel, Microsoft Access MVP

> I have a dropdown on a form and can't seem to figure out how to display the
> value of BOTH columns once the selection is made instead of just displaying
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Ken Snell [MVP] - 14 Oct 2005 21:55 GMT

See this ACCESS Web article:
http://www.mvps.org/access/forms/frm0058.htm

Signature

Ken Snell
<MS ACCESS MVP>

>I have a dropdown on a form and can't seem to figure out how to display the
> value of BOTH columns once the selection is made instead of just
[quoted text clipped - 10 lines]
>
> Thanks.

Reply to this Message

[MVP] S.Clark - 14 Oct 2005 22:04 GMT

In Access, we call these ComboBoxes. DDL are the web-speak.

You can concatenate fields together in a query to be displayed in the
unopened combo. Also, setting the Number of Columns,
Bound columns, and column widths property.

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting

>I have a dropdown on a form and can't seem to figure out how to display the
> value of BOTH columns once the selection is made instead of just
[quoted text clipped - 10 lines]
>
> Thanks.

Reply to this Message