Populating a ComboBox via a Query with conditional criteria

[Shinta]

Greetings:

I'm wish your help in a query concept; I'm pupulating an unbound ComboBox with a Query via the QueryDesigner. The value of the Rowsource depends on the value of another ComboBox at the main Form.

After several hours of trial and error, I came to the solution showed at the attached image ("works"); my concern is.. why does my first approach does not work via the IIF clause? ("not work")

Thanks a lot in advanced..

Regards

 

[llkhoutx]

Use the query by example window, then the query builder to reference the 1st combo box in the query's criteria row.

 

[Shinta]

Greetings...

Could you expand a little bit your explanation? I just couldn't catch it ...

Thanks a lot in advanced..

Regards,