I have three listboxes like above in same table with Different name but data is same. If I select 1st listbox 2nd and 3rd shouldn't select any values. If I select 2nd listbox, both 1st and 2nd should select values and 3 rd shouldn't. Simillarly If 1st,2nd and 3rd select listboxes it should total values in one Textbox. The Selection is always forward direction only.
If the values in the three columns are associated in any way, then a selection in one list box will affect the possible values or selection in the other list boxes. This behaviour is by design and cannot be overridden.
Assuming that the columns are not associated, then I think you will need to use OnSelect triggers for Col1 and Col2. The OnSelect trigger for Col1 should fire an action to clear the selections on Col2 and Col3 (Select in Field action, Search String "=null()") . Likewise the OnSelect trigger for Col2 should clear the selections on Col3. I expect that this approach will fail if the fields are associated.
Hope that helps
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
