More than one field bound to combo

C

chris

I have a combo which fills in an applicant's name (from tblPerson) in
a table (tblProject) but I also want to fill in the applicant's ID in
the same table. I need both fields in order to record the applicant's
name at the time of application but also to maintain the link to the
person via the ID to cover circumstances where the name in tblPerson
may in the change in the future. Can anyone suggest how I can do this.
Chris
 
R

Rick Brandt

chris said:
I have a combo which fills in an applicant's name (from tblPerson) in
a table (tblProject) but I also want to fill in the applicant's ID in
the same table. I need both fields in order to record the applicant's
name at the time of application but also to maintain the link to the
person via the ID to cover circumstances where the name in tblPerson
may in the change in the future. Can anyone suggest how I can do this.
Chris
Click to expand...

ComboBox with two columns, one with ID and one with name. Display either
one or both in the drop-down and make the first column (Column(0)) the bound
column. In the AfterUpdate event of the ComboBox have code...

Me!SomeOtherControl = Me!ComboBoxName.Column(1)
 
Top