Forms Update Field

[Dsully]

I have First Name and Last Name fields in my tables and
form. I want to have a field that joins these 2 fields to
give me the Full Name of the person. In the form I have
the Full Name field set to:
=[LastName] & ", " & [FirstName]
Which gives me the required information to view as I go
from one record to the next but the field in the table
remains blank. I want the Full Name field in the table to
update as a user fills in the information in the First
Name and Last Name in the form.
Any ideas as to how I may able to do this?

 

[Jim Allensworth]

I have First Name and Last Name fields in my tables and
form. I want to have a field that joins these 2 fields to
give me the Full Name of the person. In the form I have
the Full Name field set to:
=[LastName] & ", " & [FirstName]
Which gives me the required information to view as I go
from one record to the next but the field in the table
remains blank. I want the Full Name field in the table to
update as a user fills in the information in the First
Name and Last Name in the form.
Any ideas as to how I may able to do this?

Don't do it.

Why? Because in a relational database, information should only be
stored once. You can always put them back together when you need to
with a query - or expression.

- Jim