Run Macro only if certain form is open

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

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?
 
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.
 
Thank you. That makes sense.
--
Thanks,
Chuck


StrayBullet via AccessMonster.com said:
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.
Click to expand...
 
Chuck,

You can use a Condition in your macro, like this:
[Screen].[ActiveForm].[Name]="whatever form"
 
That is exactly what I needed.
--
Thanks,
Chuck


Steve Schapel said:
Chuck,

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

--
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?
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

Opening form unexpectedly closes other form 0
Create Fillable PDF Forms With LibreOffice Writer 3
Click a subform field to open relevant form 5
Form Not Closing 1
Return without GoSub 3
filtering a form based on a filter on an open form 2
Access Command to run access, open to specific form and specific record 1
Access Open Form with WhereCondition 6

Back
Top