in the trigger ON OPEN
i wrote= max(year) and max(year,2) and max(year,3)
which should select max 3 yr on open...but its not working
Try to change the trigger condition like below
For multi selection you need a '|' between values and brackets around
Retrieving data ...