How to preview a report of a single record using a command button in form?

[Maxjoo]

I do not remember to have asked this before...

I have a form showing records for a particular building. I added a command button to show the record I have on the screen, using a report; but when I click on the command button, the report shows ALL the records in the DB. How can I make the report to show the current record? I know I have to use a macro (or a similar instruction) or the "On Current" property, but HOW? THANK YOU IN ADVANCE!!!!!...

[Jamesy_007]

I do not remember to have asked this before...

I have a form showing records for a particular building. I added a command button to show the record I have on the screen, using a report; but when I click on the command button, the report shows ALL the records in the DB. How can I make the report to show the current record? I know I have to use a macro (or a similar instruction) or the "On Current" property, but HOW? THANK YOU IN ADVANCE!!!!!...

Hi Maxjoo,

To get pass this issue, you have to place a criteria on the ID field within the RowSource property of the report....

As an expression it will look something like this

[Forms]![theFormName]![ID]

This expression will select the exact record you are on and will generate the report you want....


Regards

[pbaldy]

Or you can use the wherecondition argument of OpenReport:

https://www.baldyweb.com/wherecondition.htm

It would be more flexible than what was suggested, which is also somewhat incomplete.

[Maxjoo]

Hi Maxjoo,

To get pass this issue, you have to place a criteria on the ID field within the RowSource property of the report....

As an expression it will look something like this

[Forms]![theFormName]![ID]

This expression will select the exact record you are on and will generate the report you want....


Regards

I am doing something wrong because I am not getting the results I want...

[Welshgasman]

I would also use the WHERE option of the OpenReport command.

[pbaldy]

The method I suspect jamesy was going for was not described for a rookie to follow. They were likely leading you towards using a criteria in the report's source query. That would work, but is less flexible.

[Welshgasman]

I am doing something wrong because I am not getting the results I want...

When in doubt, Google for the syntax and how to use the command.

https://learn.microsoft.com/en-us/of...cmd.openreport

https://www.google.com/search?q=docm...hrome&ie=UTF-8