Hello Maria,
What you are asking for can absolutely be done through vba.
And I also find it a great idea that gives an additional dimension of usability to comboboxes.
I have created a sample database (both .accdb and .mdb) that does absolutely what you want (..I hope :)).
Inside you will...