i have a main form with a subform, this subform is filtered with a query looking at a certain field on the main form.
I want the user to be able to input an additional filter string and filter the subform again. So the query has to be extended with the input field. At first the input field will be empty and is not included in the query statement.
I could easily create a seperate qeury , but how do i apply this query to the subform ??