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.