Results 1 to 2 of 2
2003-03-07, 18:07 #1
- Join Date
- Aug 2002
- Santa Maria, California, USA
- Thanked 0 Times in 0 Posts
Filter for combo box (Access2000)
Good morning Loungers,
I have two queries (TutorApptQry) and (StudentApptQry) the common key is the GroupNo.
The TutorApptQry has only one record for each GroupNo and the StudentApptQry has one or more records for each GroupNo (more than one student can be in a tutoring session with the tutor).
I created a form with a combo box to select the GroupNo from the TutorApptQry, this works just fine no problem. Then I have another combo box on the form in which I want to display ONLY the students that are attached to the selected GroupNo.
The query has only two fields, the student name and the GroupNo and I have included in the query grid the criteria
2003-03-07, 19:17 #2
- Join Date
- Dec 2001
- Melbourne, Australia
- Thanked 32 Times in 32 Posts
Re: Filter for combo box (Access2000)
In the AfterUpdate event of the first combo box (cboGrpNo) you need to place the following statement:
I have assumed that your second combo box is named cboStudents.
Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>