print command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top