Combine 2 text fields into one

[aclayton]

I have a table called frmReps which has information such as Last Name
and First name.

I then have a command button on my main form that links to a secondary
form called frmPersonal which houses personal info such as ssn spouse
and dob. On the frmPersonal i want to pull the Last Name and First
name from the frmReps form and format it to be LastName, First name
instead of 2 seperate text fields.

I do not want to record this data in any way to the table i just want
to be able to have it display on the second form.

Currently i have the frmPersonal using the following expression in the
control source in order to pull over the Last and First names - =Forms!
frmReps![Last Name] and =Forms!frmReps![First Name]

Any advice on how this can be done?

Thanks.

 

[mscertified]

Try:
=Forms!frmReps![Last Name] & ", " & Forms!frmReps![First Name]

Its best not to have embedded blanks in your column names!

Also, I would caution you against storing ssn in any Access DB. It's not
secure and you would be open to legal liabilty if the ssns ever fall into the
wrong hands. Employees should have a unique personal id unrelated to ssn.

-Dorian

 

[tedmi]

=Forms!frmReps![Last Name] & ", " & Forms!frmReps![First Name]
Note that there should be a blank after the comma.