Making a combo box change a combo box

[Mary Hartman]

I am putting a database for a music instrument company.

On the import form I have 2 combo boxes.

The first has categories such as:
Books
Stands
Cases
in it.....

I would like to make the 2nd box reference a table related to the 1st
box. In other words, when Books is selected, I would like to combo
box to reference the table that has:

Children's Music
Beginners
First Year
etc.

And when cases is selected, I would like it to reference,
Canvas,
Leather,
Fabric,
Etc.

How do I manage this?

Thank you.

 

[Ken Snell \(MVP\)]

See this article:
http://www.mvps.org/access/forms/frm0028.htm

 

[Douglas J. Steele]

You might also find
http://office.microsoft.com/en-ca/access/HA011730581033.aspx?pid=CH063650361033
useful.