I would like to know a VBA code that I can use in combo operation as follows. I have a table from which the combo looks up employee IDs but the same table has other data such as employee name, address and salary scale. Now I want such that when I select an ID it should also transfer and display the other values for that particular ID such as name, salary scale etc

Bright

Bmulenga

__________________
Bmulenga

If your combo contains and displaying columns like Id, EmpName, BasicSalary and so on then you could write following.

Let us say you have placed 3 text boxes named EmpId, EmpName and EmpBasicSalary on a form along with the combo.

On the AfterUpdate event of Combo, write the following code

Me.EmpId= me.Combo.Column(0)
Me.EmpName= me.Combo.Column(1)
Me.EmpBasicSalary= me.Combo.Column(2)

The sequence of column in the combo always begin with 0. Means Id will have Zero position and EmpName column will have 1st position and so on.

Hope this help

With kind regards,
Ashfaque