Form with dependent combo boxes (beginner)

Hello-

Very much a beginner at Access here.  I'm trying to create a form for data entry, and may have several questions, but let's start with this one:

I am entering data related to employee attendance at professional development sessions.  There are six categories of sessions, and each category contains about 20-40 independent sessions.

For the first two steps of the data entry process, I would like to have two combo boxes: one in which the category is selected, and the second in which the exact session in question  (sorted by data and course title) is selected.  Of course, I would rather not have the second combo box contain over 200 sessions. 

The question is thus: How do I make the contents of the second combo box dependent on those of the first, so that if a particular category is selected in the first, only the sessions in that category are displayed in the second?

Thanks in advance.

You asked:

For the first two steps of the data entry process, I would like to have two combo boxes: one in which the category is selected, and the second in which the exact session in question  (sorted by data and course title) is selected.  Of course, I would rather not have the second combo box contain over 200 sessions. 

The question is thus: How do I make the contents of the second combo box dependent on those of the first, so that if a particular category is selected in the first, only the sessions in that category are displayed in the second?

I suggest:

The first combo box has options listed in a query or table showing the categories. 

The second combo has options listed in a query.  Within that query, you limit the results based on the selection chosen in the first combo box.

In the OnChange property of the first combo box, you issue a requery to the second combo box to update the list of options.

Hope this helps, even though I now see my answer was pretty late in arriving.

8^D