VBA Msgbox after update

[shamas21]

Hi All

My question actually has a bigger picture to it but i want to make it simple.

I have a form. I have a table as the data source to the form. I want a message box to pop up if the user makes a change to a record.

Thats it! However i cant get it to work. I use the form after update event and it produces an error saying this module or class doesnt support this ....

can someone help?

thanks

 

[boblarson]

Use the form's On Dirty event.

 

[pbaldy]

What code did you try? There should not be a problem with a simple message box in either the before or after update events.

 

[shamas21]

The on dirty doesnt work either.

The code is simple. its:

Private Sub Form_AfterUpdate()

MsgBox "You changed a record!"

End Sub

 

[pbaldy]

Can you post a sample? That should not error.

 

[garyholc]

I would add it to the field's AfterUpdate event so when the user changes the field and tries to move away from it, the msgbox will appear.