Printing ONLY the current form??????

[Mendoza007]

When I've created a print command button on one of my forms it prints out all the records not just the one which is being viewed. How so I tell it to only print out the form containing the active record???????

 

[Oldsoftboss]

You must set criteria on your cmdbutton code

Create a report from a query and set the criteria there

Dave

 

[ghudson]

If you are not using a continous form and you want to print the form [simple screen print of the form] for the current record you can use this...

DoCmd.RunCommand acCmdSelectRecord
DoCmd.PrintOut acSelection

The advantage is the "what you see is what you get" effect is printed.

 

[DJBummy]

Never ceases to amaze me how simple the solutions are. Worked like a charm for me.

 

[cgardner]

Print Screen

Is there a way to "format" a print screen command to ensure that it prints on one page only?