URGENT - OpenReport when Form closes

  • Thread starter G S via AccessMonster.com
  • Start date
G

G S via AccessMonster.com

Im really out of ideas on this project i need this week. I have a macro
I have it

OpenForm
ShowAllRecords
ApllyFilter

Then user is then able to edit the form the results which go to a table when
they click a button.
I made a report that runs from that table. The problem is I would like to
add to the macro Open Report so that it would look like
OpenForm
ShowAllRecords
ApllyFilter
Open Report (with the condition being that the report would not open until
they have closed the form)

Is this at all possible?????
The reason I dont just put the thing OnClose within the form is because I
have several macros that could be run all depending on what buttons they
click on the main menus.

Please help if you can
Gabriel
 
S

Steve Schapel

Gabriel,

No, you can't do it like that. The OpenReport will have to be part of a
separate macro, assigned on a separate event. If the On CLose event of
the form is not applicable, maybe you need another command button on the
form, specifically to print the report via its Click event.
 

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