Hi have 2 forms a main form and a sub form. The main form has 2 unbound combo boxes. call it box1 and box2.
What I am trying to do is filter a combo box in the sub form based on the values picked from box1 and box2 from the main form. I have been using the standard =[Forms]![MainForm]![Subform].[Form]![Value] behind the record source of the combo box on the sub form.
However, this seems to work for the first record in the subform. when I try to select another value for record 2.
Record 1 A) disapers if it does not match the values of either combo box 1 or 2 from the main form
B) If I use me.refresh on the form. all of the values dissaper even though they are added into the tabe.