Please Help-Pop up message box

[jamesc]

I have created a form that shows different records from a customer table. What I want to know is how to create a pop up message box that lets me know when new records have been added. Thanks.

 

[Dwayno]

Assuming that you know enough code to create the MsgBox and create a cmdButton. You could create a Command button forcing the person to use it to addrecord then attach code to send the MsgBox. Better would be the above but have it email or even update a table on your client or faceplate.mdb that way you would have a record of it rather then use a MsgBox. If this isn't what you are looking for email me with more info. good luck.

 

[Ron Bell]

Try this if you've not already:
Find your Forms 'After update', event procedure and enter:

msgbox "your msg",48,"I've entered something"

after new record entered and you go to next record this msg will appear
this will also appear if you amend any record on form so maybe not as required

you change stuff in quotation marks"" to suit
nb: 48 = exclamation mark icon, others are availabe, VB standard values