combo box problems

[Brad]

I am a teacher trying to set up a data base that would
keep track of fees charged for lost and damaged textbooks
for my school.

Each Textbook has three fees associated with it: full
price, half price and "damage fee".

I would like to create a form where I could choose a
textbook title from a combo box and then have the fees
associated with that textbook appear in another combo box.

I can get the textbook titles to appear in the first box,
but how do I make the fees associated with that book
(which are in the same table) load into another box?

Thank you...

 

[Douglas J. Steele]

See whether the sample code in http://www.mvps.org/access/forms/frm0028.htm
at "The Access Web" gives you a push in the right direction.