Run Macro only if certain form is open

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chuck - 06 Mar 2008 00:39 GMT

I have programed a maco to open one of various forms depending on criteria on
an open form. Is there a way to run a "follow up Macro" based on which form
opens? In other words can I run a macro based on wheather a certain form is
active?

Signature

Thanks,
Chuck

Reply to this Message

StrayBullet - 06 Mar 2008 01:01 GMT

Take a look at the RunMacro Method of the DoCmd object. You can have it as
part of the OnLoad of the form in question.

>I have programed a maco to open one of various forms depending on criteria on
>an open form. Is there a way to run a "follow up Macro" based on which form
>opens? In other words can I run a macro based on wheather a certain form is
>active?

Reply to this Message

Chuck - 06 Mar 2008 01:21 GMT

Thank you. That makes sense.

Signature

Thanks,
Chuck

> Take a look at the RunMacro Method of the DoCmd object. You can have it as
> part of the OnLoad of the form in question.
[quoted text clipped - 3 lines]
> >opens? In other words can I run a macro based on wheather a certain form is
> >active?

Reply to this Message

Steve Schapel - 06 Mar 2008 02:25 GMT

Chuck,

You can use a Condition in your macro, like this:
[Screen].[ActiveForm].[Name]="whatever form"

Signature

Steve Schapel, Microsoft Access MVP

> I have programed a maco to open one of various forms depending on criteria on
> an open form. Is there a way to run a "follow up Macro" based on which form
> opens? In other words can I run a macro based on wheather a certain form is
> active?

Reply to this Message

Chuck - 06 Mar 2008 16:37 GMT

That is exactly what I needed.

Signature

Thanks,
Chuck

> Chuck,
>
[quoted text clipped - 5 lines]
> > opens? In other words can I run a macro based on wheather a certain form is
> > active?

Reply to this Message