Message Box Reminder on close or Before Update?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K. Boomer - 07 Oct 2008 22:18 GMT

I would like a message box to appear once the user has filled out the form
and wants to close it or move on to the next record.

It's a simple reminder message and does not require any input, nor does it
rely on data in any other field on the form.

"Verify calibration equipment has been added to database!" Then the form
closes after this appears.

Thanks in advance for your assistance.

Reply to this Message

Dirk Goldgar - 07 Oct 2008 22:29 GMT

>I would like a message box to appear once the user has filled out the form
> and wants to close it or move on to the next record.
[quoted text clipped - 4 lines]
> "Verify calibration equipment has been added to database!" Then the form
> closes after this appears.

If the user doesn't have to confirm the update, it makes sense to put such a
message in the form's AfterUpdate event:

Private Sub Form_AfterUpdate()

MsgBox ""Verify calibration equipment has been added to database!"

End Sub

The message will be displayed any time a record is saved, regardless of
whether the save occurred because the user moved to a new record or because
they closed the form. It will not be displayed if nothing on the form was
modified (by the user or by your code) so that no record will be updated or
added.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Pendragon - 08 Oct 2008 00:16 GMT

In the On Close property of the form:

MsgBox "Verify calibration equipment has been added to database!", vbOKOnly
DoCmd.Close

> I would like a message box to appear once the user has filled out the form
> and wants to close it or move on to the next record.
[quoted text clipped - 6 lines]
>
> Thanks in advance for your assistance.

Reply to this Message

boblarson - 08 Oct 2008 04:41 GMT

No, Pendragon - Dirk's response is correct. You can't put it in the form's
close event because the user may not close the form. They may just go on to
the next record. So, the form's After Update event makes sense for this.

Signature

Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

> In the On Close property of the form:
>
[quoted text clipped - 11 lines]
> >
> > Thanks in advance for your assistance.

Reply to this Message

Mike Painter - 08 Oct 2008 04:56 GMT

If they have to do this I would think that the messasge should be placed in
the field(s) where the calabration is added and the form kept open until
then

> I would like a message box to appear once the user has filled out the
> form and wants to close it or move on to the next record.
[quoted text clipped - 6 lines]
>
> Thanks in advance for your assistance.

Reply to this Message

K. Boomer - 10 Oct 2008 15:15 GMT

Thanks to all for your response. The first reply from Dirk worked fine.

> If they have to do this I would think that the messasge should be placed in
> the field(s) where the calabration is added and the form kept open until
[quoted text clipped - 10 lines]
> >
> > Thanks in advance for your assistance.

Reply to this Message