Hey everyone, I need a hand with getting a certain field to do two things. I have a combo box (Employee Name) that, when selected, brings up the Employee Number in the adjacent field. HOWEVER, this number is NOT stored in the associated table! Gar! I realize that the control source can either be a reference to the table or a reference on the form, but I need it to fill in the number based on the name AND put it in the respective table.
In my control source, it references the ID properly with this expression:
=[EmpName].column(1)
I tried comming up with expressions to do both store and reference data, but I can't. I have very little VBA experience. Any suggestions guys?
PS: The employee name field is [EmpName] and the field that will be pulling data from that field based upon the name is [EmpID]. I can't get the [EmpID] to show up in the table, it just says "0".
Thanks
In my control source, it references the ID properly with this expression:
=[EmpName].column(1)
I tried comming up with expressions to do both store and reference data, but I can't. I have very little VBA experience. Any suggestions guys?
PS: The employee name field is [EmpName] and the field that will be pulling data from that field based upon the name is [EmpID]. I can't get the [EmpID] to show up in the table, it just says "0".
Thanks