Filter by Form

[Lloyd]

Is there a way to open a form with a macro or VBA
in "Filter by Form" mode?

Thanks. Lloyd

 

[Bob]

Use the following code in your On Open event for the form.

DoCmd.RunCommand acCmdFilterByForm