Filtering data to a report.

  • Thread starter Thread starter Jim Lonergan
  • Start date Start date
J

Jim Lonergan

Hi Folks,

I have a property database that contains information about
15-30 properties. I then have a number of smaller
databases linked to this main db. There is a neat wizard
that allows me to put a button on my property form that
opens a sub database with only records from that current
property. For instance, I bring up the property to site
1AB and I have another database linked to this property
database for employees. When I click on the button for
employees on the property form, it only brings up the
employees from property 1AB.

I've noticed that the wizard does not inlude this same
neat trick for reports meaning that when I use the wizard
to make a button for previewing a report, I can't make it
bring up only the records from the current property. Is
there a way to do this?

What I am looking to do is this. Say I am reviewing the
information on the property form for property 2AC and want
to print a report of employees for just that site I would
just like to click on a button and have this report print.

Thanks for any and all guideance.

Jim
 
One way to do this is to use the command button wizard to open a form that
is filtered. Then view the code and change the form name to your report name
and the DoCmd.OpenForm to DoCmd.OpenReport.
 
Back
Top