I think this is what you're looking for...
This will open up the "Filter By Form" screen. Put it in the OnLoad event of your form, and it will run when you first open the form.
DoCmd.RunCommand acCmdFilterByForm
I tried doing this to open my form in FormbyFilter mode, but I got an error message that it couldn't find the macro DoCmd. Do I need to set up a macro?