Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There are two listboxes of 'YEAR'.
Suppose first listbox is in state 1 and second listbox is in state 2
now if i select 2005 in first listbox I want that second listbox should display values greater than 2005 and they should also be available for selection.
If i want to calculate the difference of Sales(per say) between year 2005 and 2008
Then i should be able to select 2005 from first listbox and 2008 from second. also if i select 2005 in first listbox, the values appearing in second listbox should start from 2006.
Help...
List Box 1
Field
Year
List Box 2
Use below expression instead of Field Year
=IF(Year>GetFieldSelections(Year),Year)
Paromita,
Please don't create multiple threads for same query. Conditional display of values . The discussion in the thread already there would help others to figure out what exactly you want; therefore it gives you better chance there to be answered.