Filter Parameter For A Query. Dependant ComboBoxes

[Faraz A. Qureshi]

I have two forms.

Form I consisting of a field "Clients" & "Products".
Form II consisting a similar fields "Clients" plus "Products" in form of
ComboBoxes.

I want the Form II "Products" Combo Box to be reflecting only those as per
the Form I which pertain to the "Client" Selected in the first combobox.

Please see if you can help me, specially by giving me a source of a similar
sample file.

 

[Larry Linson]

I have two forms.

Form I consisting of a field "Clients" & "Products".
Form II consisting a similar fields "Clients" plus "Products" in form of
ComboBoxes.

I want the Form II "Products" Combo Box to be reflecting only those as per
the Form I which pertain to the "Client" Selected in the first combobox.

Please see if you can help me, specially by giving me a source of a similar
sample file.

The examples of this approach, often called "cascading combos", are usually
dealing with Combo Boxes in the same form. The difference is, that you will
have to either refer to the Client Combo Box in Form I from the Product
Combo in Form II, or perhaps, set a Client Text Box in Form II from Form I
in the After Update event of the Form I Client ComboBox.

In my Samples and Examples at http://accdevel.tripod.com/dwnindx.htm, you'll
find an example entitled "Query By Form with Three Combo Boxes" that might
help you, though all three of those Combo Boxes are on the same Form.

And, too, in your case, for cross-form referencing to work, _both_ forms
must be Open.

Larry Linson
Microsoft Office Access MVP