Option to select from two combo boxes to store into one field 1

[stupiet]

To anyone who can help,

I am building a data entry form that will store comments made by our employees.
Comments are submitted on a paper card and then we have a data entry person put this cards into our database. On these cards, however, the employee has the option to put down their name or their employee number.
So to make it easier for our data entry person we want to create two combo boxes: one listing all employee numbers and one listing all employee names. They have the option to use either one, which will store the employee they selected into the right field. Is this possible?
I'm having trouble understanding how I can do this when I only have one field to store this info in. I guess the two combo boxes need to be unbound and somehow have both linked to one field. Creating that link is what I have problems with.

Thanks for the help!

 

[PHV]

Set the bound field's value in the AfterUpdate event procedure of each combo.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[stupiet]

Thanks PH

It was easier than I thought!