Create a report based on current entry in form.

[jasemckee]

Hello all

I want to place a button on my form and when clicked it will produce a report on the record in a form, but only that record.

I know how to produce a report on all records but how do I go about producing a report on just one record ie the current one being viewed.

What I am aiming for is just printing off a report based on the current record, as opposed to printing of a report for all records.

I know I can select print and just select the current page, but is there a way of printing off a report, based on a report format that I have for just the current record in a form which would enable me to place a button on a form and let me do this.

I hope I have explained this well.

Thanks in advance.

Jase.

 

[KenReay]

Hi

The Openreport wizard will guide you through this.

In a nutshell you set the link criteria to the value of a unique identifier (the prime key typically), using a syntax that looks like a WHERE cluase without the WHERE Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[Garridon]

This website has instructions on how to do this:

http://www.mvps.org/access/

Just go to the reports section. Linda Adams
Linda Adams/Emory Hackman Official Web site

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com