I have a single table with 3 fields:
Table1:
empFirstName
empLastName
empFullName
In a separate Access "DB" I have a form that allows me to create, edit and delete entries on this table. The form has these three text fields:
Form1:
frmFirstName
frmLastName
frmFullName
What I am trying to do is get the frmFullName text field to auto-propegate from the frmFirstName and frmLastName fields when creating a new record. Along with that auto-propegation I need the resulting information to fill in the empFullName collumn on the linked table. I use the empFullName field on other tables and forms as a standardization technique, but for the life of me I can't figure out how to do this. I can follow the guides and get the text field to show the full name, but that requires filling specific info into the control source, which then stops the information from being saved to the table. I'm stuck and would appreciate any help.
When I enter the following line in the Control Source property box if shows up correctly on the form, but does not fill in the field on the table.
Expand|Select|Wrap|Line Numbers
- =[LastName] & ", " & [FirstName]
First Name: Test
Last Name: Bug
Full Name: Bug, Test
Getting the Full Name to fill to the Table1 empFullName field is where I am having my issues.