I am using cascading lists for three fields on an Access form. I am using an event procedure in the "After Update" field to requery when there is a change to show only the relevant data in the cascading list fields. The problem that I am having is when the user scrolls to the next record, the two fields that are fed data through the cascading list do not change. Here is an example:
Select a 'County' (combo box)
Select the 'School'(combo box), which only shows schools in that county
The 'SchoolCode' (list box) is placed here when 'School' is selected (Cascading list)
Select 'Teacher' (combo box), which only shows active teachers with that 'SchoolCode' (Cascading list)
The 'TeacherCode' (list box) is placed here when 'Teacher' is selected (Cascading list)
*** 'SchoolCode' and 'TeacherCode' do not change when moving to the next record.
Thanks for any help I can get with this.