Passing Parameter Between Two Datawindows

[Dom71555]

I have two datawindows dw_1 and dw_2
dw_1 contains all a teachers students throughout many years, designated by the column named "year" and the value '14-15', '15-16' etc..
dw_2 contains only the column "year" with the same format '14-15','15-16'.

Passing of the year works using dw_1setfilter(ls_year_filter), however I need to click the datawindow (dw_2) twice to see the changes in dw_1. This code is in the clicked event of dw_2.

ll_rownumber = dw_2.getrow()
ls_year = dw_2.getitemstring(ll_rownumber,"year")
ls_year_filter = ls_colname + " = " + "'" + string(ls_year) + "'"
li_rc = dw_1.setfilter(ls_year_filter)
dw_1.filter()

Is there a way to have the user click only once on that datawindow (dw_2) to see changes in dw_1?

Thank you for your help

 

[Dom71555]

I figured it out, all I needed to do was use getclickedrow() rather than getrow()
worked perfectly!!

Thanks again