I need to apply a filter to two subforms when my main form is opened based on input from the user.

I assume this can be done with a macro, but I'm stupid when it comes to that sort of thing.

Any help is appreciated.

MEH