I have two unbound comboboxes, one on a main form and the other on a subform attached to the mainform. The comboboxes are used to select records from their respective forms. They are populated with simple SQL queries for the rowsource, no controlsource. I have set up their "After Update" events to lookup the relevant record chosen in the dropbox and to populate their respective forms with the recordset.
I'm trying to set it up so that the user first has to select an entry from the main combobox (or add a new entry into the form entirely) before the second combobox/form is unlocked.
However, I want the second combobox to be populated with a filtered list, filtered depending on what was selected in the main combobox. For example, Albums and songs. If Albums was the mainform, and Songs was the subform, I would want the Songs combobox to be locked until the user chooses an Album. Then I want the user to be able to either:
a) Choose a song from that album
b) Enter in a new song not in the database for the album.
What do you guys think is the best way to set up the filtered rowsource for the second combobox and the locking feature?