I have a split form sourced from a query(qry1). I need to put two combo boxes (cmb1 and cmb2) on the form to filter the data sheet part (field1 and field2). When user chooses the value in either of these combo boxes, the data sheet will filter accordingly.
Meanwhile, other combo box, which the user doesn't choose from, should also change to the value of the same record row. (i.e. when cmb1=a, cmb2=aa; cmb1=b, cmb2=bb; vice versa)