Copied field fails to appear immediately

  • Thread starter Thread starter Alvin
  • Start date Start date
A

Alvin

After Update only fires when you leave the field that was
changed. If you have to have field B reflect the changes
in fild A as they occur, you'll have to use On Change.

But On Change is tricky to use, since it fires each time
any character in the field changes, so you almost
certainly won't have a valid key until after you leave the
field -- making After Update the correct choice.
 
Alvin,

Thanks for your advice.

Ray
-----Original Message-----
After Update only fires when you leave the field that was
changed. If you have to have field B reflect the changes
in fild A as they occur, you'll have to use On Change.

But On Change is tricky to use, since it fires each time
any character in the field changes, so you almost
certainly won't have a valid key until after you leave the
field -- making After Update the correct choice.
-----Original Message-----
I put below code in AfterUpdate event of field A and
expect to see the field B changed immediately. It fails
to appear immediately but after I roll the record upwards
or downwards and come back to that record, the field B
appears correctly. Both fields are of date type. Can
someone help me how to make the field B changed
immediately.

Private Sub Field_A_AfterUpdate()
[tblA.Field B] = [tblA.Field A] + 10
End Sub

Thanks,

Ray

.
Click to expand...
.
Click to expand...
 
Back
Top