Value in 2nd Combo box based on the Filter in Combo box 1

[Jwnagz94]

Hello all and thank you for helping

Situation is that i have 2 combo boxes and i wish to have the 2nd combo box to filter based on the selection of the first

I have figured out how to do this in the situation where my first combo box only has 1 field
However, in my situation Combo box one has multiple fields. Because of that i cannot seem to get [Forms]![frmEmailtest]![Test0] that criteria to work.

Any help would be awesome

Thank you!

 

[xenou]

Hi, solution would be the same as in the last thread. Did we not get that worked out?

 

[Jwnagz94]

Difference is with this i need to reference combo box one with combo box 2 being a fully functional query as well. I have multiple textboxes linked to both combo boxes.

 

[xenou]

Okay but the way you get the value from the control is the same.