Recording Previous Selection from REF Drop Down Box

[Domearian]

Hi Everyone,

Is there a way to capture the previous selection made from a REF Drop Down box before saving the form.

To clarify, I have the drop down box here which shows a current location name. If I change this, I want to record the previous entry. So if I change from Daventry to Southampton, I want to keep Daventry as a previous. And later, if I change from Southampton to Liverpool, I want the Southampton to be the previous location.

Data Used:

[Current Location] - REF (Location Data) , [Previous Location] - TEXT , [Last Move] - DateTime

I've tried using [_THISROW_BEFORE].[Current Location] but that doesn't work.

Grateful for any help with this.

[Suvrutt_Gurjar · Accepted solution]

Please try below

In the column [Previous Location] ' s Initial value setting add an expression something like 

[_THISROW_BEFORE].[Current Location]

In the column [Previous Location] ' s reset on edit setting, add an expression something like 

[_THISROW_BEFORE].[Current Location]<>[Current Location]

Please enter in the Editable_If setting of the [Previous Location]   a value of FALSE

Please make the column [Previous Location] as ref type with reference to "Location Data" table.

Now the [Previous Location] should store the previous location value.

[Domearian]

Worked perfectly. Thank you.

[AleksiAlkio]

Or do you mean it should remember the previous selection inside of the form view? What I mean.. if you re-elect it multiple times on the form view before saving it, it should always change the previous value?