How to print a record in a form by pushing a button in another form ?

[pschrader]

Hi !

I'm using MS Access 2003 and Windows XP Professional.

I should like to save the extra effort of programming reports. A lot of
effort has gone into designing the layout and arrangement of data in the
form, and the form displays the data very nicely. So I should like to use it
also for printing if I can, even if this method has some drawbacks.

I've a form A with a print button on it. Pushing its print button prints the
form as it is displaying the current record.

Now I 'd like to do the same thing by pushing a print button on another form
B. E.g., pushing the button that is on B opens the form A, prints it as it
is displaying the current record, and closes it again.

I am not a VBA programmer, but I have the very strong suspicion that a few
lines of VBA code can solve my problem.

How can this be done ?

Your kind help will be greatly appreciated.

Peter

 

[John W. Vinson]

I should like to save the extra effort of programming reports. A lot of
effort has gone into designing the layout and arrangement of data in the
form, and the form displays the data very nicely. So I should like to use it
also for printing if I can, even if this method has some drawbacks.

By far the simplest method to do this is to open the form in design view and
select File... Save As, and save the form as a report. This will carry over
all the design features of the form, even the images of command buttons and
other such stuff that will not actually operate in a report.