Hi I am having problems filtering two of my subreports on my forms :
frm_operator_search & frm_school_search
These search forms are set up to search my database (attached minus all sensitive data) to create a list of schools or operators (depending on the form) and thier relevant transport routes.
The form is filtered using either text for the school name or a combo box for Local Auhtoirity. this is all set up and working fine. Some school are served by more than one Athority and some operators also work for more than one authority, my tables are all normalised and this again is working fine.
If you search the form by Authority in the subform only that Authority which you searched for's routes come up, which is what I want..... BUT in my report form all Authorities routes to the school or provided by the operator are listed.
e.g. if you search for Amman in the text box & select city and county of swansea from the combo box only city and county routes are shown in the form. However if you preview the report both Neath and Swansea routes are shown, when I want Neath routes filtered out.
Anyone out there have any suggestions as to how the report can be made to filter the results properly?