default data on status change

  • Thread starter Thread starter cindy muth
  • Start date Start date
C

cindy muth

How do I default today's date and time into a [closed dt]
field when the [status] field is changed to "closed". The
format of the [closed dt] field is __/__/__ 10:00 AM.

I've been trying to use the afterupdate property on
[status] field and can't get the proper syntax. Thanks
for your help!! cm
 
Assume the name of the TextBox Control is "txtClosedDT", you can simply use
the AfterUpdate Event of the Control [status] to run the statement:

Me.txtClosedDT = Now()

You can set the display of this TextBox to whichever format suits you best
using the Format Property of the TextBox.
 
Back
Top