I cannot think of a code free way to do this in SharePoint 2007. In SharePoint 2010, filters are allowed, so this scenario is much easier.
If you don't want to write code, qRules has a command that works with an owssvr.dll data connection to add filters to it - the form would still have to be admin deployed in a SharePoint 2007 environment, however.