Print Report for just one record

  • Thread starter Thread starter Paul Hoyle
  • Start date Start date
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
 
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
 
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
 
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).
 
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
 
Back
Top