individual reports

[Momof2]

I have created my 1st database which is designed to track missing receipts
from individual credit card statements. It does pretty much everything I want
it to do except for one little thing that I can not figure out. I have
several 100 people in which I'm tracking back from 2006. I have created a
report which breaks down by individual what is missing. I am trying to figure
out a way in which I can just select the individual I want to run the report
for instead of it pulling up everyones information. I'm sure this can be done
just not sure where to start.

 

[Jeff Boyce]

Let's assume you are working on a form to do this.

Add a combobox that lists the folks for whom you want to do this.

Add a <PrintPreview> command button that opens the report.

The report is based on a query, not directly on the table.

The query that feeds the report points at the form to get a selection
criterion for the ID of the person.

Alternatively, you can use a report that WOULD display all folks' data, but
behind the command button, have the report open with a WHERE clause or
filter (again, using the value selected in the combobox).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP