After Update Event

[RayMilhon]

For a field on a form when does the After UPdate Event actually fire? If I'm on the form in an existing record and update the field it fires. However, when I'm on the form and entering a new record the After UPdate Event for a particular field doesn't fire anyone know why?

[pbaldy]

The event fires when the contents of the control are manually changed by the user. If you've populated it via code or default value, it does not fire.

[Bulzie]

Ray sounds like you maybe be confused with AfterUpdate event on the Form versus on a Control? You can have AfterUpdate on the Form which will fire when your record is saved or AfterUpdate on the crotrol which will fire off after you update that control value and leave the control. Even if you are on a new record, once you enter data into that field and move off of it, the AfterUpdate on that control will fire if you have code there.

[RayMilhon]

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:

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.

[pbaldy]

Can you attach the db here?

[Bulzie]

"However If I enter a new record type in all of the data for that record and then move to another record" don't understand this part. Do you mean you move to a new record? Those events should trigger even if on a new record. If you are updating a different field "recordtype"? in the same record, then no they won't trigger since you are not updating those specific fields with the AfterUpdate property code. In that case you would need to add that code to the BeforeUpdate on the Form.

[RayMilhon]

CRMNewtest.zip


Here's the file. The Actual Data is in SQL Server saved the table I need in the local MS Access 2010 DB.

[pbaldy]

Enter them in a different order, one of the names last. Hint, check the date textbox code.

[RayMilhon]

Ok Thanks, PBaldy Guess I had my stupid cap on this morning. I forgot I changed the name of the textbox due to another issue I was having. It's fixed now thanks for the help

[pbaldy]

No problem. Wish I could say I'd never done it.