Autofill Dept

[mura]

I have a form based on a table with several fields. The table contains names of employees and their departments, etc.

When I fill in the form with the employees name, how can I have it autofill the dept?

Your assistance is appreciated.

 

[roh_8_it_3]

write code in the after update of the the employee name control that will fetch the dept of the specified employee and assign it to the dept textbox.

 

[mura]

I am not a programmer and will need help with code. I need specific documentation. Thank you.