Long sentences but simple question
I have 2 filed in my form
1 - combo
1 - text
After update the combo, I check
If the value <> the old value then
Text = null,
My question is:
Example:
If the combo = 159
The text = "198589635"
After I change the combo to 170, than the text = null
Insert into the text filed the value "1111111111"
(After update the text there is a function that check if the value is valid)
Here there 2 situations that not work well
A.
I don’t go to other record and change the combo (170) to 170,
Now the text became null because the old value is 159
B
I don’t go to other record and change the combo (170) to 159,
Now the text not became null because the old value is 159, but here I want that the text became null because the value is 170
And in small words:
I want to check if the value has change
150 – 160 (V)
160 – 160 (X)
160 – 150 (V)
How am I do it?
I have 2 filed in my form
1 - combo
1 - text
After update the combo, I check
If the value <> the old value then
Text = null,
My question is:
Example:
If the combo = 159
The text = "198589635"
After I change the combo to 170, than the text = null
Insert into the text filed the value "1111111111"
(After update the text there is a function that check if the value is valid)
Here there 2 situations that not work well
A.
I don’t go to other record and change the combo (170) to 170,
Now the text became null because the old value is 159
B
I don’t go to other record and change the combo (170) to 159,
Now the text not became null because the old value is 159, but here I want that the text became null because the value is 170
And in small words:
I want to check if the value has change
150 – 160 (V)
160 – 160 (X)
160 – 150 (V)
How am I do it?