use combo box selection as subform query criteria

[Frances]

Please help! I have a table T with three data field, f1, f2, f3, a form with
three combo boxes and one subform. Combo box1 will select f1, and Combo box2
will select f2 that matches f1, then combo box3 with f3 that matches f2. The
subform should display a query with f1, f2, f3 as criteria. My subform
somehow takes f1 and f2 but not f3. So it displays all records match f1 and
f2 and everything in f3. Can someone tell me what I missed?
Is there a better way to select multiple fields as criteria?
Thank you for all in advance.

 

[Ofer Cohen]

Can you post the SQL of the record source in your sub form?
We might have an idea by looking at it.

 

[John Vinson]

Please help! I have a table T with three data field, f1, f2, f3, a form with
three combo boxes and one subform. Combo box1 will select f1, and Combo box2
will select f2 that matches f1, then combo box3 with f3 that matches f2. The
subform should display a query with f1, f2, f3 as criteria. My subform
somehow takes f1 and f2 but not f3. So it displays all records match f1 and
f2 and everything in f3. Can someone tell me what I missed?
Is there a better way to select multiple fields as criteria?
Thank you for all in advance.

What's the RecordSource property of the Subform? Please post the SQL
view. And what are the Master/Child Link Field properties of the
subform control?

If you have any code triggering the display, please post it too.

John W. Vinson[MVP]