Display information From combo box

[jds]

Heres my problem!! What I would like to do is when I select an employee from my combo box. Their information is displayed in the appropriate fields. Such as Phone #, address, workplace etc. The form I am building is an incident report form and I would prefer it if I would not have to type in their information each time I have to file a report. I'm not sure if this is possible to do, but if it is I hope someone can help me out here.

Thanx a bunch
Jds

 

[Mitch]

The best way to do it would to have the fields you wish to display as hidden columns in you combo box and set the AfterUpdate procedure to set text boxs to the corresponding column number.
[txtPhoneNo] = [cboSelector].Column(1)
[txtWorkPlace] = [cboSelector].Column(2)

Please note that column numbers are indexed from Zero.

Mitch