Restrict 1 combo box based on another combobox value

[Beth]

Hi,
This should be very easy, but isn't working right.
I have a form in continous view (which seems to be the problem).
For each record, there are 2 comboboxes. The boxes are both tied to data in
a table and the user won't necessarily touch the first combobox prior to the
secondary one.
The first box is the school year (Freshman, Sophmore, Junior, Senior).
Based on the selection for that specific row, I want to restrict the second
combobox to just the classes available for that year students.

I have tried using the following in the criteria line of the Courses column
in the row source of the second box (where the first box is called txtSchYr)
[Forms]![frmRegistrations]![txtSchYr].

In the continous view, it is selecting the txtSchYr from the first record,
so it is wrong for everyone else.

What am I missing?

Thanks in advance.

Beth

 

[Allen Browne]

The most reliable approach is to set the RowSource of the combo.

Details in:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm