Viewing one record at a time

[mcampan]

Hello,
I am very new to access and thought i was starting to understand it but am stuck on something. I built a report and am trying to be able to pick the record i view and print. I do not want to print all the records. I had a macro that i used to do this that worked until i made some changes and now i cannot figure out how i did it. I am pulling the data for the report from two different tables. The previous macro would would have a Enter Parameter Value box pop up and i would put in the ID number that i was looking for and the report would pop up for just that ID number. Thank you in advance for any help!

 

[pbaldy]

Perhaps you used the wherecondition argument?

Open a second form to the record

Most of us would use a form to gather user input rather than the Enter Parameter Value box, as you have more control.

 

[theDBguy]

Hi. Welcome to AWF!

Can you show us your macro? Thanks.

 

[onur_can]

Hello there
The simplest way to do this is to replace the record source of your report with a query that covers all fields in your table. This is to write [Enter ID] in the ID field criteria part of the query. In this way, when the report is opened, a parameter screen will appear that allows you to select the record.

 

[mcampan]

The macro i was using is this: [2021Events]![id]=[Forms]![EventsForm]![id] . I have since learned how i should be naming things to make more sense. the 2021Events should be tbl2021Events and EventsForm frmEventsForm.
I will try the other suggestions on here. Thank you everyone for the help so far and i will report back.
Mike

 

[mcampan]

It appears that Onur_Can's soultion worked! Thank you all for the help!!