SubForm & Filter

[omaggi]

Hi everyone.
I have a Form included 3 sub-Form.
At the top of the form I have 4 textbox that I use as a filter of the records I show in the sub-forms.

My problem is that for the 2 sub-forms I need to make one type of filter and with the third one, I need to make another kind of filter (this can be made with some VBA code).

Can everybody explain me how can I "say" to the form to use the "Filter 1" for the first 2 sub-form and the "Filter 2" for the third one?

Sorry for the "strange explaination"...

Thanks and big greetings.

 

[HiTechCoach]

I normally use form reference in the record source and only one line of VBA code: Me.Requery

It would help to know how you are filtering the sub forms now. Please explain in more detail what you are doing.