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

  • Thread starter Thread starter Guest
  • Start date Start date
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 said:
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
Click to expand...
 
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.
 
Back
Top