I have a main form and a subform. My subform default view is data sheet composed of rows and columns. In every row there are two combo boxes, the first combo box used to filter data of the 2nd combo box. But the problem is, when i go to the second row and update the first combo box, the 2nd combo box in the first row also change its data. What I want to happen is, the first combo box may filter only the data of the 2nd combo in the same row and must not affect the data of the previous rows.
Please help.. Thanks ahead..