print command button

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.
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Print button on Report form 3
Command Button Help. 2
Print Parameters for a Form 1
Need a button to print 5 copies 2
Printing Two Forms with one Command Button 1
Print records in continuous form 4
Printing current record of a form 2

Top