Use current record Criteria

[AmateurDBer]

Hello,

I have created a query that populates a report. The report is linked to a
button on a form. I want the report to open to a specific record tied to the
record that is open on the form when you hit the button.

Here is what I have accomplished. In the query, I know how to set it to
prompt for the record ID number that I want displayed in the report; however
this is cumbersom if I am viewing the record in teh form view. Is there a
way to automate this button to open the report for the current record that is
open in the form? If it can not be done in the query, should it be done in a
Macro?

Thanks!
The newbie

 

[Allen Browne]

See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

 

[AmateurDBer via AccessMonster.com]

Thanks, Allen! This worked great!!!!

See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Hello,

[quoted text clipped - 15 lines]

Thanks!
The newbie