Print Report for just one record

P

Paul Hoyle

Hi

I want to have a command button on a form that will print a record for
only that record.

Any help will be Very Very welcome

Thanks in Advance

Paul
 
D

Darrell Childress

Paul,
One way is to create a report based on a parameter query and use the
parameter =[Forms]![Myform].[Myfield] so that only the current record is
selectred by the query.
Darrell
 
R

Rick B

Asked and answered often. Did you try searching for this answer before
posting a new thread?

Please search before posting. That is the whole reason messages are
retained.

Rick B
 
J

Jeff Boyce

Paul

In addition to Darrell's helpful solution, another approach is to use the
OpenReport syntax's Filter or WHERE clause. The general concept is to have
the command button tell the report to open, filtered by the contents of the
form's control (as Darrell had the query do).
 
J

Jeff Boyce

Gosh, Rick...

If everyone looked first, none of us would have any reason to respond to any
posts
<g>!

Jeff Boyce
<Access MVP>

----- Original Message -----
From: "Rick B" <Anonymous>
Newsgroups: microsoft.public.access.reports
Sent: Tuesday, March 22, 2005 6:42 AM
Subject: Re: Print Report for just one record
 
Top