Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

opening forms with filter active

Status
Not open for further replies.

roblaysps

Technical User
Oct 8, 2001
2
GB
Hi, Pretty new to this, Wonder If Any One Can Help?

I Have a form to which i want to apply a filter.(filter by form) to do this I know that i have to click the "filter by form" button. How do I set the form so that when it is opened it already has the "filter by form" button depressed. i.e. so that all the user has to do is enter a value and apply the filter.
 
Add the following to your forms Load event:

docmd.runcommand accmdfilterbyform
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top