Open and Preview a Single Record in a Report

[Brian T]

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

Thanks

 

[Marshall Barton]

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

 

[Brian T]

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

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

 

[Marshall Barton]

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]

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

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