Save button on a form

[rochak]

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

[RobDog888]

Sure thas an easy one. If you create a boolean variable at the form level you can set it to false after the forms loads. Then in each control change event you can set your boolean flag to True. When you click on the save button you change it back to false. If the variable is false when save is clicked you dont write out to your log file.

[rochak]

thanks rob. Can I ask you another question?

Is there a way for me to manually set to false the form dirty property? Thanks

I made sure to rate your earlier post.

[dannymking]

rochak,

you can just do

Me.Dirty = False

[rochak]

danny, this does not seem to work. Once I have done me.dirty = false, on subsequent edits or changes to the form the dirty property is not automatically set to true again

[dannymking]

The property will switch back to true as soon as a bound field control is changed..

For example when a form initially loads it's dirty property is False

As soon as a textbox has it's entry changed if you peform a msgbox stating simply

MsgBox Me.Dirty

Then it should say True.. if it doesn't then your control is not bound.

[rochak]

yes you are right. My control is unbound. Any way to get it done in this.

[dannymking]

What you will have to do is capture the control's original value before any changes are made.. then after it has been made check to ensure that it is different and then set the dirty property to true.

[rochak]

does this mean, that I will have to do it for each and every control? Because in that case, using me.dirty is not the only soln. I might as well use any flag variable for the purpose.

[dannymking]

That is one of the things bound forms are good for..

Yes you will have to validate each control before sending it to the table..

If you do not want users directly changing the table's data then pull to a temporary table and bind the form to this.. therefore allowing an experienced user the option to review the changes and then submit them back to the main table..

[rochak]

yup thanks, it works.