Form: field #1 entry controlling choices in field #2 combo-box

[Jim Lehmann]

Greetings all. I'm working in Access 2003. Using the Students and Classes
example, I have the tables: Students, Classes, and ClassLoads (students and
the classes they are taking). Then I create another table, Papers, to hold
the titles of papers written by each student for each class. In a Form,
based on the Papers table, designed to enter the titles of papers submitted,
I want my selection of a student from a combo-box in field #1 to limit the
choices available in the Class combo-box (field #2) to only those classes in
which the student is enrolled (rather than showing all classes from the
Classes table). Is that possible?

 

[Linq Adams via AccessMonster.com]

The concept is called "cascading comboboxes." If you goggle this term or
search here and on other Access forums, you'll get about a gazillion hits.
Here's one tutorial from Bytes.Com:

http://bytes.com/forum/thread605958.html