Third Cascading Combo Box Displaying to Much Data

[ScottMSP]

Hello,

I have three cascading combo boxes in a subform: cbxSurveyID,
cbxSurveyJobNumber, cbxSurveyBreakout.

The first two combo boxes are working correctly and allows me to select a
SurveyID and then the second combo box only displays the SurveyJobNumbers
associated with that particular SurveyID.

The issue is with the third combo box. It is displaying any SurveyBreakout
that matches the SurveyJobNumber regardless of what SurveyID I have selected.

For example, when I select SurveyID 050108, and SurveyJobNumber 102, the
SurveyBreakout combo box should only display two separate breakouts that are
in SurveyID 050108 under SurveyJobNumber 102. Instead, the SurveyBreakout
combo box is displaying all breakouts that match SurveyJobNumber 102. Just
to be clear, it is possible to have the same SurveyJobNumber under different
SurveyID’s.

In this example, I need the third combo box to only display SurveyBreakouts
that are contained to SurveyID 050108 and SurveyJobNumber 102.

Thanks in advance.

-Scott

 

[ScottMsp]

I got it.

The answer was in my case, in the third combo box I needed to reference both
the second and first combo boxes. I am not sure why, but when I did that, it
worked.

 

[sanador]

Can you please elaborate? Sorry... novice here.

I got it.

The answer was in my case, in the third combo box I needed to reference both
the second and first combo boxes. I am not sure why, but when I did that, it
worked.