Combo Box - drop down list

[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

 

[Douglas J. Steele]

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.

 

[Jim Smith]

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!)






.