how to let un-select dropdown box with condition

[tongw]

Hello,

Good morning!

The following is my question:

t1(text field) t1_unit (dropdown box) t2(text field) t2_unit (dropdown box)

I want if t2 is not null then t2_unit=t1_unit otherwise t2_unit is empty

I have the expression below but not work at this point...
if(Not isnull(t2), (t1_unit), isnull(t2_unit))


Thanks in advances.

 

[mbalent]

Try

IF (IsNull(t2), t1_unit,'')

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com