Listbox should hide with selection and unselect when there is no selections

[#1]

Hello,

I've there listboxes, for this three listbox i want to perform little bit logic but i'm not able to do. I know this is silly question to ask..Can any one work out and help me.

Task:

1. By default second Listbox data will show with all selections every time in my development and the third Listbox will hide without selections.

2. Now, If i select any one value or total value in First Listbox then second Listbox values should unselect and hide it. In mean while the third Listbox should visible with all selections.

3. If i unselect the First Listbox values then third lisbox should unselect and hide it. In mean while the second lisbox should show with all selectios.

For your reference i'm attaching sample file

[swuehl · Accepted solution]

jacq.

please have a look at attached modified sample, especially at the variables defined and the actions in document triggers (OnOpen, OnChange for a vSelectedCount1).

I changed the data model to three separate tables for the three fields, so I can select and unselect independently on the fields. This is not a must for the sample to work, I just interpreted the task as such, but you could just change the data model back to your one table.

Hope this helps,

Stefan

[#3]

Thanx swuehl...