I have a report where I would like to open and print only the chosen record.  
How to I specify the record?

Thanks

Brian T wrote:

>I have a report where I would like to open and print only the chosen record.  
>How to I specify the record?


If you have a form where users can navigate to the desired
record, then add a command button to open the report.  The
code behind the button would look something like:

Dim stWhere As String
stWhere = "[primary key field]=" & Me.[primary key field]
DoCmd.OpenReport "report name", acviewPreview, , stWhere

-- 
Marsh
MVP [MS Access]

Thanks,  but is there a way to write the same thing into an embedded macro?

"Marshall Barton" wrote:

> Brian T wrote:
> 
> >I have a report where I would like to open and print only the chosen record.  
> >How to I specify the record?
> 
> 
> If you have a form where users can navigate to the desired
> record, then add a command button to open the report.  The
> code behind the button would look something like:
> 
> Dim stWhere As String
> stWhere = "[primary key field]=" & Me.[primary key field]
> DoCmd.OpenReport "report name", acviewPreview, , stWhere
> 
> -- 
> Marsh
> MVP [MS Access]
> .
> 

I don't use macros so all I can do is assume there is a way.
Probably using the OpenReport action with:
	"[primary key field]=" & Me.[primary key field]
in the WhereCondition argument.
-- 
Marsh
MVP [MS Access]


Brian T wrote:
>Thanks,  but is there a way to write the same thing into an embedded macro?
>
>"Marshall Barton" wrote:
>> Brian T wrote:
>> >I have a report where I would like to open and print only the chosen record.  
>> >How to I specify the record?
>> 
>> 
>> If you have a form where users can navigate to the desired
>> record, then add a command button to open the report.  The
>> code behind the button would look something like:
>> 
>> Dim stWhere As String
>> stWhere = "[primary key field]=" & Me.[primary key field]
>> DoCmd.OpenReport "report name", acviewPreview, , stWhere