Hi there.
I'm having a problem keeping the changes done with AfterUpdate when the record is saved. For instance, I have a database where the records are updated on a dily, weekly, monthly basis but the changes do not hold.
Example: If a certain checkbox is valued, then other fields are to be disabled/locked. While in the record when the update is made, everyhting looks good and works. However, when the record is saved and then reopened, those changes are not held.
This is my code:
Private Sub Contract_Not_Referred_for_Pre_Sig_AfterUpdate()
If Contract_Not_Referred_for_Pre_Sig = True Then Post_Load_Review_Only_Contract.Enabled = False And Post_Load_Review_Only_Contract.Locked = True
End Sub
Any help would be greatly appreciated.
I'm having a problem keeping the changes done with AfterUpdate when the record is saved. For instance, I have a database where the records are updated on a dily, weekly, monthly basis but the changes do not hold.
Example: If a certain checkbox is valued, then other fields are to be disabled/locked. While in the record when the update is made, everyhting looks good and works. However, when the record is saved and then reopened, those changes are not held.
This is my code:
Private Sub Contract_Not_Referred_for_Pre_Sig_AfterUpdate()
If Contract_Not_Referred_for_Pre_Sig = True Then Post_Load_Review_Only_Contract.Enabled = False And Post_Load_Review_Only_Contract.Locked = True
End Sub
Any help would be greatly appreciated.
