Reset on edit doesn't work with a dependent initial value

Conditions:

currently i have two cells related to each other

[Bank name] and [Bank Account No.]

When I choose a bank in [Bank name], which is ref to a list of bank names, [Bank Account No.] will put out the bank code of the bank as initial value, but sometimes it is being left out for further edit.

When I get the bank info and decided to edit the row, when i choose [Bank name], the [Bank Account No.] will stay empty, i tried is not blank and it is only resetting when thereโ€™s already value input on that cell, I want it to update when I choose the bank name when i modify the case.

Solved Solved
0 10 316
1 ACCEPTED SOLUTION

[Refund Account No.] 's Reset_On_Edit =

[_THISROW_BEFORE].[Refund Bank] <> [Refund Bank]

View solution in original post

10 REPLIES 10
Top Labels in this Space