Need help with expression

[Terry]

Okay I have two forms gathering information. The first
form gets the employee's last name, first name, ID num,
and department. The second form gets the training
information they've done and they are linked by the ID
num. When they are entering the training information in
the form they choose which employee it goes under by
picking out the employee ID num from a combo box. The
combo box also shows the first and last names beside the
number when it drops down. The problem I have is that I
would like to have a box off to the side showing the last
and first name of the person that is picked to have the
training go under. This is so that if you go through all
the form entries you can see the persons name to and not
just the ID number you've choosen.

Thanks
Terry

 

[Kevin Sprinkel]

-----Original Message-----

Okay I have two forms gathering information. The first
form gets the employee's last name, first name, ID num,
and department. The second form gets the training
information they've done and they are linked by the ID
num. When they are entering the training information in
the form they choose which employee it goes under by
picking out the employee ID num from a combo box. The
combo box also shows the first and last names beside the
number when it drops down. The problem I have is that I
would like to have a box off to the side showing the last
and first name of the person that is picked to have the
training go under. This is so that if you go through all
the form entries you can see the persons name to and not
just the ID number you've choosen.

Thanks
Terry

Hi, Terry. There are several ways to do this, including
basing your form on a query, but since your combo box
already includes the name fields, I suggest using the
Column property. The columns are numbered left to right
starting with 0. So assuming your columns are ID, LName,
FName, your textbox' Control Source might be something
like:

=Me!txtID.Column(1) & ", " & Me!txtID.Column(2)

to display:

Smith, John

HTH
Kevin Sprinkel