If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can I type in cell and the rest of the row will fill in.
If I type in a empleyees # it will bring up employees name automatlicly
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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 |
Thread Tools | |
Display Modes | |
|
|