show 2 cols in dropdown?

  • Thread starter Thread starter r
  • Start date Start date
R

r

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.
 
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
 
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.
 
Back
Top