clear a fields selected value on change event with nocode

J

jaydee

i have a cascading list box structure and need to be able to clear the 2'nd
fields selected value if the the 1'st fields selected value is changed.
Nocode !!
 
E

Ed Thurber

Set up a rule on the first dropdown to set the values of the other two to
nothing.

The Rules button is on the first page of the Dropdown List Properties dialog
box.

A better approach is to set a rule on the first dropdown to clear the second
and a rule on the second to clear the third. when the first rule fires it
will trip the second rule.

Ed
 
S

Swathi (GGK Tech)

Hi,

1.Go to first list box properties by double clicking on it.
2.Click on Rules in data tab.
3.Click add.
4.Click add action.
5.Select ‘Select a field’s value’ in action drop down.
6.Select the second list box in Field.
7.Click ok until all windows gets closed.
 
K

kleone

Hi, I have a similar situation, but slightly more complicated. I am also
wanted to clear the values of subsequent drop downs when a previous value is
changed, however, I have Form Rules applied that prepopulate information
based on user ID when the form is opened...when I use the control rules to
clear the next fields, my Form rules get overwritten(in other words, I open
the form, and the values are now blank instead of prepopulated)...any
suggestions would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top