How could I populate an employees name add last name automatically once I
have selected the employee's ID.
Thank you.
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
