How to put a message box & have the user not close it?

[Juan]

Is it possible to put a message box out for say at the
beginning of a sub and then have it be close by the end of
the sub? But I don't want the user to be able to close
the message box. I want the message box to be told with
code to close when it is about to get out the sub. I am
coding in VBA.

Thanks

 

[Dev Ashish]

Is it possible to put a message box out for say at the
beginning of a sub and then have it be close by the end of
the sub?

Not directly with the built-in MsgBox function. You'll have to create your
own form to represent the Message Box; open the form at the start of the
proc, and close it with Docmd.Close acForm call in error handling code and
at the end of the proc.

-- Dev