I have a form based on a table. Upon saving the newly added records I also want to concatonate two fields on the form and add them to the table into an existing column "Fullname"
The two boxes to be concatonated on the form are "Name" and "Lastname" (both bound)
I then draged the "Fullname" onto the form from the feild list and changed its control sourcew to be =Form!Name & [Surname]
This works so much as in it displys the correct info in the field when the two bound boxes are filled in but does not save that record to the table?
Where am I going wrong?
The two boxes to be concatonated on the form are "Name" and "Lastname" (both bound)
I then draged the "Fullname" onto the form from the feild list and changed its control sourcew to be =Form!Name & [Surname]
This works so much as in it displys the correct info in the field when the two bound boxes are filled in but does not save that record to the table?
Where am I going wrong?