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.
 
You must log in or register to reply here.

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

Increment a Short Time Field by 15 minutes 2
Coding - Form Status 1
Unable to LockBoundControls based on bound combobox value 1
Event Procedures on Forms 4
Passing value of a form control in the Row Source to a Chart 3
Using IIf + default value for a combo box 4
Individual Status Indicators changing individual background colors of record 0
Make a field NotNull based on a contion in another field 3

Back
Top