The control is on a Data Entry Form. In the After Update Event of 3 controls (lastname, firstname and DOB) I have the following code:
Code:
If Not Isnull(me.lastname) and not isnull(me.firstname) and not isnull(me.dob) Then
me.personkey = Trim(left(lastname,4)) & Trim(left(firstname,4)) & Trim(format(me.dob,"mmddyyyy"))
End if
If a record exists and I modify any of those fields the Me.PersonKey field is populated as it should be. However If I enter a new record type in all of the data for that record and then move to another record the PersonKey field in the table is still blank. If I go back to that record and change any of those 3 fields the PersonKey field is populated.