Pop Up Message

[Crampton]

Is there a way of sending an automatic message or displaying a popup box to other users when a record in a form has been created?

Thanks for your help

 

[Mark Wild]

How does the user "save" the record? Do you have a save button?

If so, you want to set up a msgbox with the message required.

In code try

msgbox "You have successfully created a record", vbinformation, "Well done!"

If you use macros, i think messagebox is a docmd action

 

[Crampton]

Thanks for that help Mark, this is certainly what i was looking for, can i also let other users know about the new record and not just the operator who created it.

Ie Sales user creates record and recieves a confirmation message, also the workshop department receives the same message ( e-mail prehaps)? to let him know about the new record.

Thanks for your help

 

[Mark Wild]

It certainly is possible to send an email to notify other users.

Have a look at postings by BukHix who seems to be a bit of a guru on this issue.

Rgds