Best Event For Record Update

[TimTang]

Hi All,

I've got a date field in a form which indicates the last time a record was updated. I'm currently updating it manually but I want to automate it. I've already written the code and it works; I just need the best place to put it.

I don't want the date to change if your just looking at a record, but I do want it to change if there are any updates to the record. Also I don't want it to change for every field; just once.

What would be the best event to place my code into to accomplish this.

Cheers

 

[MichaelRed]

On Dirty


MichaelRed

 

[TheAceMan1]

How are ya TimTang . . .

The forms [blue]Before Update[/blue] event occurs just before a record is saved, and isn't triggered unless the current record has been edited (Dirty property = True). The [blue]Before Update[/blue] allows you to [blue]undo record changes[/blue] (maybe you edited the wrong record!)

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TimTang]

Thanks to everyone.

It almost works but if I put the code into BeforeUpdate
I start getting this error:

"Update or CancelUpdate without AddNew or Edit Error"

How do I get rid of that?

Cheers!!

 

[TheAceMan1]

TimTang . . .

If your updating to the current date, then all you need is:

[blue]Private Sub Form_BeforeUpdate(Cancel As Integer)
   Me![[purple][B][I]DateFieldName[/I][/B][/purple]] = Date
End Sub[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TimTang]

Thanks TheAceMan1!

I'll try that as soon as I can get back into my database.

I got the "Hide Access container window" to work so well that now I can't get back in!

I tried the hold-shift but it doesn't seem to work.

Oops! Cancel that; it just worked.

Cheers!!