Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Santa Maria, California, USA
    Posts
    3
    Thanks
    0
    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

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Filter for combo box (Access2000)

    In the AfterUpdate event of the first combo box (cboGrpNo) you need to place the following statement:

    Me!cboStudents.Requery

    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>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •