how can I type in cell and the rest of the row will fill in.

[William from fl]

If I type in a empleyees # it will bring up employees name automatlicly

 

[Duane Hookom]

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.

 

[william from fl]

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



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

 

[Duane Hookom]

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.