print command button

K

Karen TS

I am trying to add a print command button in a form, that will print only the
record that is currently on the screen. Right now the button I have added
proceeds to print all records that I have added. This is in the "forms" area
(not the reports). Help please.
 
B

Brian

Personally, I would just create a report and then filter to
{Forms]![yourFormName]![PrimaryKeyID]. Someone else may know how to do it for
just the form.

If you really want to print the form and just the current record, however
(assuming that you used the button wizard and ended up with a
DoCmd.PrintOut), edit your VBA code to this:

DoCmd.PrintOut (acSelection)
 
Top