Macro HELL

[Joe C]

Hello,

I have a macro that basically run based on a condition. In the acutal macro
I have condition 1 and it's results then condition 2 and it's results listed.
The problem I have is when I have it listed condition 1 then 2 one condition
1 will work. Naturally, when I list them 2 then 1 only condition 2 works.

I am using 2003. Any help would be appreciated.

JC

 

[KARL DEWEY]

You kinda lost me. Do you want to run based on condition 1, based on
condition 2, or based on both condition 1 & 2?

If that is what you want then set three conditions in the macro --
If Cond 1 and Not Cond 2 Action
If Cond 2 and Not Cond 1 Action
If Cond 1 and Cond 2 Action

 

[Joe C]

Karl,

You may have answered the question but I want either of the conditions. I
have two conditions, sick and vacation. Within the macro I have it so that if
sick is true then setvalue .... On the next line of the macro I have if
vacation is true the setvalue ...

When I am in the form and select sick it only works if sick is the first
item in the actual macro. The same is true for vacation. If I select sick and
it's true and vacation is the first if statement in the macro the macro does
not do the sick condition.

Does that make sense?
JC

 

[KARL DEWEY]

Post your conditions. Your wording seems to say you are using "IF" in the
condition.