time stamp upon closed

S

scott04

Hi Everyone,
I am trying to have a time stamp mark my date_completed field when an
operator changes the status field to closed. Closed is in my tblstatus table
along with submitted, pending, postponed, ect. I am guessing that the code
would be in the afterupdate event of the status field on my form but not
sure? Iwould rather the system date the field rather than an operator. Any
suggestions?
 
K

Klatuu

I would suggest that you use a combo box for the status field. That way, the
correct codes will always be entered.

Then to update the date_completed field in your table, put a text box on
your form that has enabled set to No and locked set to yes. That way the
operator can see it, but can't change it manually.

Now, in the after update event of the status combo, populate the
date_completed control.

Me.txtDateCompleted = Date
 
Top