ms access update field when another field changed
Posted on 2011-03-03
I am trying to update a field when another field change. However, after i change the field you won't see the change until you click on another field in the form. Is there any way to change the field without having to click another field. I guess when you move the mouse off the field. I tried other events like on change, on lost focus, but they more or less do the same.
Private Sub S_N_BeforeUpdate(Cancel As Integer)
If Me.p25.Value = True Then
Me.pEsn.Value = Me.[S/N].Value
Me.pEsn.Enabled = False