Reseting Conditional Value lists

[Zero Tolerence]

Just thought I'd share this with you all, most of you probably know this, some of you might not.

I have a few forms that have to be worked in a certain order.

Dropdown list 2 is based off a relationship between dropdown 1.

The problem I've been having, in 8, is that when the user goes back, and changes dropdown1, dropdown 2 does not change. My end users often don't notice this, and thus have bogus data in their final form. So here is what I have done.

I have changed the field DropDown2 to be an auto enter calc. with replace exisiting value unchecked, and the evealute if ref'd fields are empty box unchecked also. I put in this calc:

Evaluate(Quote(""); DropDown1)

What this does, is ANYTIME that DropDown1 is changed DropDown2 is cleared, giving the user a visual saying, I need to put something there!



If you want to clear it out based on numerous fields being changed you can just add the fields like this.

Evaluate(Quote(""); [Field1; Field2; Field3; Field4])

Anyhow, this was a life saver for me, maybe it can help someone else too.

[hexxabubba]

that was hot!