printing query problem

[bacardi451]

Hello. I have a print problem I made a query, then built a form with the information of the query and made a report for the query. Now this is where my problem starts I put a print commad button on the form so I can print the form but I end up with all the records printed in form view. How do I set the command button to print the selected record only vice all the records. I do not have a table and cannot set the ID key in the macros.

 

[ppete]

If you look at the code behind your Print command buttond. Is there a line that reads

DoCmd.PrintOut

If there is change it to:

DoCmd.PrintOut acSelection

That should do it I think.

ATB,

Pete

 

[bacardi451]

Pete,
the line behind the command button reads:
DoCmd.OpenReport stDocName, acNormal

I changed it to DoCmd.PrintOut acSelection it will print out the form not the report.

Thanks in advance
Al