Form View

[citloner]

How can I get a form, based on a table, to show only certain records (for
example, only paid customers)?

I tried basing the form on a query but it didn't work.

Thanks,
Courtney

 

[John Spencer]

That is the way you would do it.

You can restrict the records that the form displays based on criteria in the
query. Did you apply any criteria to the records in the query?

You can also filter records in a form using the form's filter property

By the way, it didn't work is not very descriptive and of very little help
in diagnosing a problem and suggesting solutions.

Did you get the wrong records, all records, no records, an error message, or
did your computer catch on fire, crash, etc.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Marshall Barton]

How can I get a form, based on a table, to show only certain records (for
example, only paid customers)?

I tried basing the form on a query but it didn't work.

Try again ;-)

If you explained what table fields are involved in
determining what a "paid customer" means, maybe someone
could make a meaningful suggestion about writing the query's
criteria.