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

 

[Pat Hartman]

You must use queries as the RowSources and you must requery the combos in a cascading mannor.
When combo1 is changed, combo2 is requeried in combo1's AfterUpdate event.
When combo2 is changed, combo3 is requeried in combo2's AfterUpdate event.

The query for combo3 references combo2 in its selection criteria
The query for combo2 references combo1 in its selection criteria.

 

[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

 

[Pat Hartman]

Your queries should have criteria in the fomat:

Where SomeField = Forms!YourFormName!YourComboName;

The requery code is:

Me.SomeComboName.Requery