Need Report for Single Record

[sandingdude]

I have a report for people donating to our charity. It lists all the people that have donated between a certain date. I have to create a thank you letter that states all the donations from a specific donor. I have a form with the persons name, address, and all donation info. I need to put a button that runs a report (aka thank you letter) for that record I am viewing at that given moment.

Thanks

 

[dhookom]

You can add a command button using the wizard. When the wizard has finished, it will have created the code to open the report in preview mode. Open the code module and modify it like:

Dim strWhere as String
strWhere = "[DonorID]=" & Me.txtDonorID
DoCmd.OpenReport "rptThankYou", acPreview, , strWhere

This assumes you have a numeric primary key in the donor table named [DonorID]. Modify the code to fit your report, field, and control names.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[sandingdude]

Duanne

I've been trying what you've said but when I run the report I get MS Visual Basic Compile Error which says "Method or data member not found".

Any ideas?

Thanks

 

[sandingdude]

I get the error here:

Me.txtDonorID

Thx

 

[dhookom]

You must substitute your field and control names to match your situation. What value on your form matches a field in your report's record source? What data type is the field?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]