Message Box if a change has been made

[hazeleyre23]

Hi,



I was wondering if there was a way to have a message box pop up, if a change has been made.

I have a comments box, in which if a manager makes a change to a member of staffs file then they have to put comments in. However if they do not make any changes then they do not need to put comments in.

I currently have this, however this pops up every time, even if a manager just views a staff file. I only want it to pop up if a change has been made.

    If IsNull(txtComments) = True Then
        MsgBox "Please enter Comments."

thanks

[John_G]

When do you want this to happen, and where do you currently have the code?

Do you want the comment to be entered if any change id made to any field?

You could end up with a circular argument too, because adding comments is also a change to the record.

I think what you want is possible, but it will require some VBA, and careful analysis of the logic involved.

[hazeleyre23]

I think I may have found another route I can use, by creating an Audit trail.

thank you for your assistance though