Opening Access report relevant to form data

[MrCroquet]

I have been asked to refine our church's database (MS Access 2000). The current report shows the donations made by individual parishioners with one parishioner per page (unless it overflows to a second page).

To find "John Doe's" individual report, the entire report needs to be searched, page by page. The main form of the database provides the personal details of each parishioner. I'd like to create a button that will open up the report specific to that person.

Can anyone tell me how to filter the report so when it opens, it only shows the parishioner who's record is current in the 'Main Form'?

 

[RuralGuy]

See if this link helps:

http://www.mvps.org/access/reports/rpt0002.htm

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[dhookom]

Hi Allan, when did you get awarded MVP? I don't think I have seen you in the Access MVP NG (unless it's my old age catching up to me ;-)

Duane
Hook'D on Access
MS Access MVP

 

[RuralGuy]

Hi Duane,

That pleasant event happened October 2007.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[MrCroquet]

Thanks for all the help. The report is now functional as required.

 

[RuralGuy]

Glad we could help. Thanks for posting back with your success.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit