Automatically change Update date on another field change

[JimO]

I have a form 'SportsMLBFrm' (continuous) to track team standings (win/loss). When I change either field [W], [L] the win loss [WinLoss] percent updates. I would like to have the date in the field [Updated] change to the current date when the [WinLoss] field changes. I would think some event like After Update or On Change is the way to go but I am not sure of the next step.

Jim O

[vicsaccess]

That all depends on how you did everything else. Is the forms recordsource the table or query or unbound, different ways of setting it up and each might be a little bit different of an answer. My guess is that your form is based on the table so yes the after update event is what i would do but keep in mind that the form is continuous so to update a single record you will have to reference the ID of the line in an update SQL. Something roughly like

currentdb.execute("update form1 set date=" & date & "where formID=" & me.id.value )

if you build it as a separate sub then you can call it from an after update event of anything on that record.
Good luck