I want to "filter by form", using criteria set up in a subform on the main form. The problem with this of course is that it will only list subform records within the current main form record - I want it to list all main form records which have subform records that suit these criteria. Has anyone found an elegant way around this?
I've been fiddling with going to a new form, based on a query that contains all of the information - this results in a lot of duplication and of course if I try grouping the results I then have records which are not allowed to be edited. A long and messy way around which doesn't do the job properly anyway!
I've been fiddling with going to a new form, based on a query that contains all of the information - this results in a lot of duplication and of course if I try grouping the results I then have records which are not allowed to be edited. A long and messy way around which doesn't do the job properly anyway!