RE: Create a condition in Macro

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Sheila:
I wrote in the first line the questions to appear when the answer "yes" is
chosen equal to "True", and on the following line of the same macro I wrote
the questions to appear if the answer chosen is "no" and made it equal to
"False". However, when either answer is chosen both set of questions appear,
what should I do?

Miguel

"Sheila D" wrote:

> Miguel
>
> You only need 1 macro, it needs to include what to do if the anser is true
> and on the next line another condition with what to do if the answer is false
>
> HTH
>
> Sheila
>
> "Miguel Vivar" wrote:
>
> > Hi Sheila:
> > Yes, it worked, I put the macro in the afterupdate and now the question
> > appears after choosing "yes". Unfortunately, I have another question. Now,
> > after answering either "yes" or "no" (this is a different question in my form
> > by the way) I want to make appear a different set of question on the screen
> > according to the option chosen (yes or no). I have created two macros, one
> > for each set of question. In other words, I have created a macro that makes
> > the set of questions to appear after choosing "yes", and I have created
> > another macro that makes a new set of questions to appear after choosing
> > "no". However, after choosing any option (yes or no) both set of questions
> > appear on the screen, what can I do to make the set of questions to appear
> > according to the previous anwser "yes" or "no"?
> > The action is "openform", and the question has a checkbox.
> >
> > Miguel
> >
> >
> > "Miguel Vivar" wrote:
> >
> > > Sheila:
> > > Just to let you know; I put the Macro in the AfterUpdate.
> > >
> > > "Sheila D" wrote:
> > >
> > > > Miguel
> > > >
> > > > Can you tell me what else you have in the macro? How are you outputting the
> > > > question - is it a message box or another field/label on the form, give me
> > > > more detail and I will try to help
> > > >
> > > > Sheila
> > > >
> > > > "Miguel Vivar" wrote:
> > > >
> > > > > Sheila:
> > > > > Both answers (yes and no) still make the question to appear
> > > > >
> > > > > "Miguel Vivar" wrote:
> > > > >
> > > > > > My problem is that I want a question to appear right after a "yes/no"
> > > > > > question is responded in my form. If the answer is "yes" I want the new
> > > > > > question to appear, and if the answer is "no" I don't want the new question
> > > > > > to appear on the form. I want to use Condition on Macro, but I'm not sure
> > > > > > what to write on the Condition. Would somebody help me?
> > > > > >
.

Quantcast