Sorry I may have done that wrong but if you look at original post I attached a file there.
So I am doing a database of my CD collection, now I love Excel but has been a while since I have worked in it like this, so I am rusty and MS has taken a lot of things a way..
Any ways once I add the CD's to my list I would like to go back and edit them as to whether I have them as an MP3 format. I have not gotten to the Option buttons yet so those on frmEdit don't work yet.
So because most artist and or groups have more than one album I would like to populate the cboAlbum with all albums corresponding with the artist in cboArtist, but I will only select 1 Album at a time to update.
Hope that explains a bit more.
And thank you for your quick reply.