Filters

B

Beetle

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.
 
J

John W. Vinson

Can you make filters on forms more or less permanent?
Click to expand...

The simplest way would be to base the Form on a Query including the same
criteria as the filter.
 
N

needing help

Can you expain to me in simple terms how to do that? I'm not familiar with
queries...
 
N

needing help

Can you expain to me in simple terms how to do that? I'm not familiar with
queries...
 
J

John W. Vinson

Can you expain to me in simple terms how to do that? I'm not familiar with
queries...
Click to expand...

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
 
Top