Form View

  • Thread starter Thread starter citloner
  • Start date Start date
C

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
 
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
..
 
citloner said:
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.
Click to expand...


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.
 
Back
Top