Close active form while printing and reopen form in add mode

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

Guest

On my Order form there is a print button. There is a print procedure in
the"on click" event. I tried putting a "close" macro followed by an "open in
add mode" macro in the "on exit" event of the print button. It closes ok when
I push the print button, but it does'nt reopen. When I "run" the macro with a
form open, it works perfectly. I would appreciate some help on this. I use
the macros because I'm not much on writing code.
 
I got it to work by creating a macro: "Open Report, Print, Hidden", "Close
Report", and "Go To Record, New". I put it in the "Click" event on the print
command button.
Some fancy code would have been nice, but it works.
Thanks
 

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
Opening form unexpectedly closes other form 0
Combo Box values are not updated untill the form is closed/reopene 2
Open Form in Add Mode 1
Form Not Closing 1
How to print a record in a form by pushing a button in another form ? 2
Refresh Form 1
Closing and re-opening forms on exit 8

Back
Top