Auto-filtered reports

  • Thread starter Thread starter Alexander Fry
  • Start date Start date
A

Alexander Fry

I have a shares database in which one particular field
contains repeated occurrences of the same datum (Mr.
Robertson, for example, owns five different types of share
and therefore turns up five times).

I wish to set up a means of quickly creating reports
filtered by name - finding all of Mr Robertson's shares,
for example. Is it possible to do this in a more user-
friendly manner than /setting a query/, /filtering it/
and /creating a report from the query/? To do this
repeatedly would be a truly tedious task.

Thanks,

Alex
 
Alexander,
There are several ways to solve this problem... I'd go with a Dialog form
that allows you to enter the Name you want to report on.
Build a little form (example name: MyReportDialog), and place a Combo box
on it (ex. cboCustName). That Combo should list all the names available to
report upon.
Select the name you want (ex. Bob Smith), and on the AfterUpdate event
for the Combo... write code Open your Report.
Now... in the query behind the report, in the field associated with the
value in your Dialog ComboBox (CustName), place this criteria...
=Forms!MyReportDialog!cboCustName
When the report runs, it will refer to form MyReportDialog - cboCustName
for the value that will "filter" the report for that CustName only.
 
Back
Top