combo box

[PhoneBooth]

I'm making a music database with access mostly for the experience, and I was trying to get combo boxes to work.

1. On my add album form there is a space for you to put the artist but I don't want to have to type in the artist every time so I'm trying to use a combo box bound to the artist column of the artist table, but I dont know how.

2. On my add song page You select the artist and album with combo boxes, but the album combo box needs to change.

If you select Red Hot chili peppers in the the artist box then Dani california, and by the way will be in the album box. But if you select linkin park then collision course will show up.

I figured out the answer to question 1 now all I need is help with 2.

Edited August 8, 2006 by PhoneBooth

[kdyer]

If you look at http://candace-tripp.com (you will have to use FireFox to get there).. She has the following:

Cascading Combo Boxes Database that should help you along.

Kent