Chnge contents of one combo box depending on values of another combo box

[saleemMSMS]

i have 2 tables namely
Books ( BooksID, BookName, Price)
Magazine (MagID, MagName, Edition)

also i have another table.
Orders (OrderID, BooksName/MagName, NoOfBooks)

now i have a form for the Orders Table. the form has 2 combo Boxes. one the first combo box says whether its a Book or Magazine (its sort of hard coded) then depending on the 1st Combo box, the values of the 2d combo box should change. if Book is selected, all the bookNames should be loaded into the 2nd combo box where as if magazine is selected, all the magazine values should get filled.

how am i to do this in access ?
please answer. thankyou...

 

[missinglinq]

The concept is called cascading comboboxes, and if you plug this term into the search box here and/or elsewhere, I suspect you'll get a gazillion hits. Here one link to get you started:

http://bytes.com/topic/access/insights/605958-cascading-combo-list-boxes