Cascading combo box not updating when new selection made in Access 2007
Posted on 2009-02-23
HI there, I know there are heaps of topics on Cascading combo boxes and I have followed each one carefully but cannot work out why I am having this problem.
I have a form called frmEnquiry and it has two combo boxes: Course and Topic. When you select a value in Course, then it will show the Topics related to that course
The row source for Course is qryCourses and for Topic, is qryTopic
I have created two queries:
qryCourses - select CourseId, Course from Courses
qryTopic - select TopicId, CourseID, Topic from Topics
and in the criteria, I have typed [Forms]![frmEnquiry]![Course] (in the design view)
In the After_update property for Course, I have used Me.Topic.Requery and I have used the same for the Current property for the form.
When I view the form initially, the second combo box is displaying the correct values however if I change the value in the Course Combo box, it is not being passed through to the Topic Combo box so the Topic combo box is still showing the values from the first selection.
I have been over this several times but cannot work out why it is not working.
Any ideas would be much appreciated