default data on status change

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
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing value of a form control in the Row Source to a Chart 3
Using IIf + default value for a combo box 4
Event Procedures on Forms 4
Insert Date into Field2, the first Time Field1 is Populated with Dataon Form 2
Peculiar default cell format 1
Count number of rcd on continuous form. 3
Publisher is filling blank lines with data 2
return without gosub error 0

Top