Command button

[Peanuts]

Hi, this is probably forms 101, but I just can't get things to work. I built a form, reports etc. On my form page I installed a command button to print a report. It works but it wants to print all 150 entries in my form. I just want it to print the report of the current entry of the form that I am on. What do I write in the Docmd. line to accomplish this? Thanks

 

[KevinM]

Add a WHERE condition referencing the PK field on the form.

 

[Peanuts]

Thanks Kevin, I finally got it figured out. My problem was "where" I was sending it. report name vs id number. Duh. NOW, that I/we have it printing the correct file in the report, I need to have it make three copies. Can you help me on that?

 

[KevinM]

Dim x as Integer

For x = 1 to 3

Docmd.OpenReport.....

Next x