• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • Last Modified:

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.
0
nysoscdesktopsupport
Asked:
nysoscdesktopsupport
1 Solution
 
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()
me.cboteachercode=me.teacher
me.cboschoolcode=me.school

end sub
0
 
nysoscdesktopsupportAuthor Commented:
thank you for your help...it 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.
0
 
Andrew_WebsterCommented:
(Don't forget to accept this solution so Cap'1 gets the points he deserves!)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now