I'm creating a search form. Instead of having a huge query, the simplest way would be to have my main form (frmAgents) open with "filter by form" already applied. Ideas on how to do this are greatly apreciated. Also I need to put a cmdButton on the form that is accessible while the filter by form is applied. When I apply the filter by form, my cmdButtons are unavailable. My database users are EXTREMELY inexperienced and don't need the extra confusion of clicking the "filter by form" icon and the clicking the "apply filter" icon. I'm sure y'all understand. Thanks

You can use the DoCmd.RunCommand acCmdFilterByForm

Command to set to filter by form.

There are other acCmds to do the other filters/Remove filters.

I don't see how you are going to get away with not having a button to start the Filter by form and another button to remove the filter. You need something to trigger the events. (And a Timer just is not going to cut it http://www.access-programmers.co.uk/ubb/smile.gif )

Thanks for your help. I'll see if i can come up with any other ideas.