Please, please help!

[Joanne]

Please, I have set up cascading list boxes. The first list box is a drop
down of attorney names (data source is an Access database, tblmentors). The
second list box is a drop down of attorneys who are being mentored by someone
in the first list box. The second list box is also from the same Access
database (tblmentees). This part is working fine. If I pick a mentor, the
correct list of his/her mentees comes up in the second box. My problem is
that I then have a repeating table which is supposed to only list certain
fields relating to the particular mentee but what it does is list all of the
mentees of the mentor. In other words if JSMITH(mentor) is mentoring AJONES,
BALLEN, and CCHARLES, the detail list has all of those names instead of just
the one chosen in the second drop down. I cannot figure out what I'm doing
wrong and I've been working on this for a week. PLEASE HELP! PLEASE!

 

[S.Y.M. Wong-A-Ton]

If your form is bound to the database, you can use a filter on the repeating
table. You would have to set up the filter (use the Filter Data button on the
Display tab on the Properties dialog box of the repeating table) to filter on
the mentee that is selected in the second drop-down list box.