On Dec 17, 9:59 am, SpaceCoorDinator
<SpaceCoorDina...@discussions.microsoft.com> wrote:

Assuming that you are selecting from a combo box

1) query for combobox should include the emplyee name as well as the
ID, You can allow the user to see or not see the name by changing the
field length for the column that contains the name to 0 or an
appropriate length.
Column cout should be number of columns, Bound column should be the
column of the employee ID, and the column widths should be appropriate
values to show or not show the field in the dropdown.  example: 1.0";
1.5"  would have 1 inch for the ID and 1.5 inches for the name.

2) In the afterupdate event of the combobox please code

   me.nameoftextfieldthatshowsemployeename =
me.comboboxname.column(n)

The n is the number of the column in the query that contains the
employee name with a zero base count.
First column in query would have n =  0
Second column would have n = 1.

Ron

In addition to the approaches Ron offers, there may be a difference of
definition.

What do you mean when you say "populate ...automatically"?  Populate what?
Why?\

Regards

Jeff Boyce
Microsoft Office/Access MVP