I have a Main form with a subform window. The main form has 6 buttons that sets the Source Object of the subform window to the form the button relates to.
The question I have is, if I apply a filter to one of the subforms, how would I then keep that filter on when changing the source object to a different form?
(i.e. User filters on field1 from form1 and it returns 300 of 15000 records. The user then wants to filter from field2 on form2 but only on the previously 300 returned records).
Any help would be greatly appreciated. Cheers
The question I have is, if I apply a filter to one of the subforms, how would I then keep that filter on when changing the source object to a different form?
(i.e. User filters on field1 from form1 and it returns 300 of 15000 records. The user then wants to filter from field2 on form2 but only on the previously 300 returned records).
Any help would be greatly appreciated. Cheers