Open form with macro

[J. Silva]

I wolud like to open a form with a a button, but only if the nearly field has
"yes", if this field has a "No", than I would like that a mensage would say
that this form doesn't exit.

Thanks,
Joana.

 

[Steve Schapel]

Joana,

In your macro design window, if you can't see a 'Condition' column you
can activate it from the View menu. Then in this column put...
[Nearly]="yes"
.... and in the Action column select OpenForm, and enter the name of the
form in the argument s section at the bottom. Then, in the next row of
the macro, put this Condition...
[Nearly]="No"
.... and for the Action put MsgBox, and enter your message text in the
argument section.

 

[J. Silva]

Thank you again!! That's very very helpful!
Joana

"Steve Schapel" escreveu:

Joana,

In your macro design window, if you can't see a 'Condition' column you
can activate it from the View menu. Then in this column put...
[Nearly]="yes"
.... and in the Action column select OpenForm, and enter the name of the
form in the argument s section at the bottom. Then, in the next row of
the macro, put this Condition...
[Nearly]="No"
.... and for the Action put MsgBox, and enter your message text in the
argument section.

--
Steve Schapel, Microsoft Access MVP

I wolud like to open a form with a a button, but only if the nearly field has
"yes", if this field has a "No", than I would like that a mensage would say
that this form doesn't exit.

Thanks,
Joana.