Cascading Lists in Access Forms

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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
you need to use the form's current event to change the values of the combo boxes to match the values of the current record.

something like this
private sub form-current()

end sub

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nysoscdesktopsupportAuthor Commented:
thank you for your helped to reach the solution. I did use the form's 'current' procedure but in it I had to call the 'afterupdate' subs that I had written for the cascading fields. Thanks again.
(Don't forget to accept this solution so Cap'1 gets the points he deserves!)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.