Cascading Combo Boxes: How do I populate the second box?

By mwisejay ·
I'm using MS ACCESS 2007. I've created a Form which has two combo boxes. The first Combo1 will populate with all the tables in the database. I've got that box working.

I need the Combo2 to populate the ReportingPeriod field from the table selected in the first Combo1 box. Any ideas?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by oldbaritone In reply to Cascading Combo Boxes: Ho ...

Try writing an event for OnChange for Combo1 that will populate Combo2

Collapse -

Reponse To Answer

by mwisejay In reply to OnChange

My understanding is that the code is supposed to go under AfterUpdate(). I just need the appropriate code to pull the specified field in the selected table from Combo1.

Collapse -

Problem Solved!

by mwisejay In reply to Cascading Combo Boxes: Ho ...

I had the right code. The problem was that my Table names had "-" and "/" symbols in the table names. Once those symbols have been removed, it works!

Related Discussions

Related Forums