The combo box is on a form. Where did you want to type in the employee
number?

I assume you don't want to store duplicate data.

--
Duane Hookom
MS Access MVP


"william from fl" william from wrote in
message ...


"Duane Hookom" wrote:

I assume you have an employee table with all the information. I would
create
a combo box based on this table and include all the columns you want to
"bring up". Name the combo box cboEmployeeNum. You can then add other
text
boxes and set the control sources to something like:
=cboEmployeeNum.Column(1)
=cboEmployeeNum.Column(2)
=cboEmployeeNum.Column(3)
Theses text boxes will display the 2nd, 3rd, and 4th columns from the
combo
box.
--
Duane Hookom
MS Access MVP
--

"William from fl" William from wrote in
message ...
If I type in a empleyees # it will bring up employees name automatlicly

I understand the table part but how do you do a combo box and where do
you type the controls in excel it is at the top but where in access