Combobox question

[manic]

this is my dilemma here: I have a few forms that have a a combo box that drop downs with over 100 employee names, each employe has its own id aka 4 letters of his name or whatever, so they are all different, how can i have the employee id appear on a field on a forms that requires it based on the selection from the combo box, so basically if i select john doe from the cbo his id will automatically fill the field that requires his id input.
any help with this will be most appreciate it.

[pbaldy]

Well, normally the ID field would be the bound column of the combo, but perhaps you want this?

http://www.baldyweb.com/Autofill.htm

[manic]

Perfect, just what i wanted, just like the tutorial says, my case is a rare one.
thanks for all the help.

[pbaldy]

Happy to help.