Software

Ask something
Question Locked

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

0 helpful
4 replies

by mwisejay

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

4 replies

by oldbaritone

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

by mwisejay

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.

by mwisejay

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! :D

This discussion is closed to new replies.