I think I'd use dependent lists to do this. Take a look at this
http://www.contextures.com/xlDataVal02.html
--
HTH,
Barb Reinhardt
"Peggy" wrote:
This must be so simple and has probably been done a million times. I want a
list of Artist that opens a list of cd's that opens a list of songs on the
cd. I would rather do this in Excel as my Excel abilities far out weigh my
Access abilities.