Hello Experts:
I have a fundamental question about cascading **UNBOUND** combo boxes.
First, please see attached database example. It includes the following:
1. Organization table
2. Billets table
3. Junction table
4. Query
5. Form
Additional details:
- The junction table stores the keys between the Organization table and Billets table. There's also a staff member ID; however, for purposes of this example, I removed the staff member table.
- Next, the query displays more detailed information and shows which billets (jobs) belong to which organization (N-Code).
- Now, in the form, the "N-Code" combo simply displays the three (example) N-Codes.
- Unfortunately, however, when changing the N-Code, the associated billets (jobs) are currently not properly showing in the 2nd combo.
What VBA code needs to be added to have the two combos in sync (based on N-Code selection)?
Please remember both the form AND the combos are UNBOUND... and I'd like to keep them unbound.
I'd welcome if you could provide specific change recommendations.
Thank you,
EEH