3 Cascading Combos

[jmeek]

Can anyone kindly help me with the attached
database. I need to synchronize 3 combo boxes.
based on the choice made in the previous box.
I have seen it done before using text fields but
not using numeric fields as in my case here and
without using queries.

I have set the RowSource for the 3 boxes on the
OpenForm event and have removed all my code
attempts.

Thanks for your help

 

[jmeek]

3 Combo Boxes

Hello Pat

Thanks for your reply. Could you kindly
give me an example where or how to reference
the combos in the sql or query code.
eg. in combo2 after update reference combo3
with an sql statement.

Thank you