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! Go to Solution.
[Refund Account No.] 's Reset_On_Edit =
[_THISROW_BEFORE].[Refund Bank] <> [Refund Bank]
User | Count |
---|---|
15 | |
11 | |
11 | |
8 | |
3 |