Jumpin' Print

[alex]

I have a Form that allows users to print the Form and attach it to a
file.

I used the DoCmd.PrintOut.

This worked very well, but when the user wanted to add more records,
every time he/she printed, every record would print.

I then used DoCmd.PrintOut acSelection to fix this problem.

This also worked well and stopped the multiple record printing. The
problem with acSelection, however, is that once a user hits the
command button, the focus jumps to the top of the page.

I've tried adding commands to set the focus back to the print command
or to a command close to the print control. What this did, however,
is cut the page off right below the command.

Can anyone suggest how to code the print command so that the focus
does not move once it executes?

acSelection appears to be my only option, but I could be wrong.

alex

 

[Allen Browne]

Creating a report is the best solution, Alex.

Details in:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html