lesleyag
asked on
Cascading combo box not updating when new selection made in Access 2007
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]![Cour
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
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]
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
lesleyag,
As you know, you are only allowed one question per post.
Can this be a new question?:
"One more thing I forgot to ask, how do you resize a form in Access 2007? I want to display the form above as a small form on the main form but control its visibility so don't want to have a full-size form.
...This is so you can get one answer to one question.
It also gives other experts a chance to help you out.
Thanks
;-)
JeffCoachman
As you know, you are only allowed one question per post.
Can this be a new question?:
"One more thing I forgot to ask, how do you resize a form in Access 2007? I want to display the form above as a small form on the main form but control its visibility so don't want to have a full-size form.
...This is so you can get one answer to one question.
It also gives other experts a chance to help you out.
Thanks
;-)
JeffCoachman
ASKER
sorry I clicked the button before I had typed this part but I will put it as another question
ASKER