Auto Close Form

G

Greg Franke

Is there a way to open, print, then close another form withing a different
form in VBA?

Say I am in FORM1 and I want code to trigger the opening, printing, then
closing of FORM2.
 
G

Guest

You should use a report, printing a form doesn't always give the desired
resault, form are not ment to be used as report.

For your question, try

Docmd.OpenForm "FormName"
Docmd.PrintOut
Docmd.Close acForm ,"FormName"
 

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

Top