Hi,

I have a weird problem. In one of my forms which allows users to edit the record on my database, I have a save button. When the user has edited the form and clicks on the save button, the record is saved. I also have to maintain a log of who is accessing my database and doing what, so I have a separate function called log_save() which I call everytime the user clicks on the save button. But the problem is that if the user clicks multiple times on the save button, I get multiple entries on my Logtable. Is there a way to identify if a user has made any further changes after he has clicked the save button once? (Just like it is in microsoft word or whereever, when the user has clicked on the save button once and if he doesn't make any more changes then he can simply exit without being prompted to save changes again) I tried using form's Me.dirty event but apparently it doesnot serve the purpose.

Thanks