 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Filters
Can you make filters on forms more or less permanent? You can create a query that only pulls the info you want from the table, then use the query as the recordsource of your form.  Signature_________ Sean Bailey > Can you make filters on forms more or less permanent? Can you expain to me in simple terms how to do that? I'm not familiar with queries... > You can create a query that only pulls the info you want from the table, > then use the query as the recordsource of your form. > > > Can you make filters on forms more or less permanent? >Can you make filters on forms more or less permanent? The simplest way would be to base the Form on a Query including the same criteria as the filter. SignatureJohn W. Vinson [MVP] Can you expain to me in simple terms how to do that? I'm not familiar with queries... > >Can you make filters on forms more or less permanent? > > The simplest way would be to base the Form on a Query including the same > criteria as the filter. >Can you expain to me in simple terms how to do that? I'm not familiar with >queries... Well, you'll need to get familiar. Queries are ABSOLUTELY ESSENTIAL to any productive use of Access. Since I have absolutely no knowledge of your database, I don't see how I can give any specific advice; but you can use the Query tab on the database window to create a new query based on your table. Use the Criteria line to apply the same criteria that you want in the filter. Save the Query and use it as the Recordsource for your report. And... learn about queries. You'll be glad you did. For tutorials see Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials SignatureJohn W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.