Sub Form

  • Thread starter Thread starter Lee Wold
  • Start date Start date
L

Lee Wold

Novice here!

Have a sub form embedded in a form which links to a table which returns
several hundred records for a particular outlet selected.

How can I either :-

1) Limit the subform to only return the top 10 matching records (already
sorted into descending order) rather than all records :
or
2) Limit the print function to only print the 10 records on show in the
sub-form (sub-form currently has a scroll bar allowing you to move up and
down all records.


Would really appreciate some help.


Many thanks.
 
Lee,

You can restrict the records in the subform by basing it on a query
which uses the Top predicate. If you use the query design view, you
can right-click anywhere on the background of the upper panel of the
design window, select Properties from the popup menu which presents
itself, and enter 10 in the Top Values property. You will also need
to enter a criteria so the query selects according to the records
matching the main form record.

Whereas it is possible in Access to print a form, this is not their
primary function, and functionality is limited. For presentation of
data, use a Report.

- Steve Schapel, Microsoft Access MVP
 
Back
Top