Open form with macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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


J. Silva said:
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.
Click to expand...
Click to expand...
 
Back
Top