Combo Box

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I'm trying to use the Combo Box function in a form so that data entry can be
done by selecting from a list of optional entries. When I use the form to
enter data, rather than inserting the option that I select, it enters the
value of the corresponding ID field. Is this function really that limited,
or is there a trick to it that I'm missing?
 
I'm trying to use the Combo Box function in a form so that data entry can be
done by selecting from a list of optional entries. When I use the form to
enter data, rather than inserting the option that I select, it enters the
value of the corresponding ID field. Is this function really that limited,
or is there a trick to it that I'm missing?
Click to expand...

The Combobox will display the first visible (non zero-width) in the
rowsource. But you can bind the value (usually the ID) to a field in
your main table for your form.

Try making the ID field have a width of zero, or if you need to see
it, make it a subsequent field instead of the first one.

The combobox wizard can help set this up for you.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
is there a trick to it that I'm missing?
Set the Column Widths property like this --- 0"; 1.5"
This sets the ID display to zero inches wide and the next column to 1.5
inches.
 
Well technically you actually want the ID field. Then you link on it in a
query to return the values that you actually want to see.

However if you don't have it set to Limit to List, it doesn't work right
anyway.

Instead of basing the combo box on a table, create a query with the field
that you want first and use it. Another advantage is that you can sort the
values now.
 
Back
Top