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

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?