Combo Box - drop down list

  • Thread starter Thread starter Jim Smith
  • Start date Start date
J

Jim Smith

Hello,

I want to place a combo box on a form. The contents of the
combo/list will be based on a query.

I will be selecting two fields from a table:

employeeID
employeeName

I want employee name only to appear in the combo box drop-
down list but I want to use employeeID as the field that
updates the control source.

I don't seem to be able to do this - the best I can do is
to create a combo box with both fields in the drop-down
list. Not what I want at all!

Any help would be greatly appreciated.

Thanks

Jim
 
Put both fields in the combo box, but set the Column Width for the first
column (employeeID) to 0. (The Column Width property accepts a number of
semi-colon delimited widths, one for each field in the Row Source) Leave the
Bound Column to 1 so that the employeeID is what's stored in the bound
field.
 
Thankyou.
-----Original Message-----
Put both fields in the combo box, but set the Column Width for the first
column (employeeID) to 0. (The Column Width property accepts a number of
semi-colon delimited widths, one for each field in the Row Source) Leave the
Bound Column to 1 so that the employeeID is what's stored in the bound
field.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.
Click to expand...
 
Back
Top