Two in report

  • Thread starter Thread starter rob peterson
  • Start date Start date
R

rob peterson

Report open event:
Macro1 runs. It brings up a form for a client ID range.
I have Macro2 that should bring up a form for a DATE range in the same
report.

I have a macro for each but can only put one in the on open event. What
should I do?
How can I get one to run, then the other?
They look like this:
Macro1:
macroopen1 openform
not isloaded (clientform) cancel event
macroclose1 close
macroOK1 setvalue
macrocancel1 close

Macro2:
Macro2:
macroopen2 openform
not isloaded (dateform) cancel event
macroclose2 close
macroOK2 setvalue
macrocancel2 close


thanks.
 
Rob,

You can put both OpenForm actions in the one macro. If you set the
Window Mode argument of the OpenForm to Dialog, it will wait for you to
close it before the macro proceeds.

However, whu not just have the one form, to cater to both the ClientID
and Date criteria?
 
Back
Top