How do I get the date on a form to =now() after I select a check box?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Hugo11
    New Member
    • Sep 2010
    • 1

    How do I get the date on a form to =now() after I select a check box?

    the attachment shows the part of the form that requires this feature
    Attached Files
  • munkee
    Contributor
    • Feb 2010
    • 374

    #2
    Place a text box where you wish the now() to show up as per your image.

    Then in the onclick event of the checkbox use similar to the following code:

    Code:
    Private Sub Check75_Click()
    Me.txtbox = Now()
    End Sub

    Comment

    • liimra
      New Member
      • Aug 2010
      • 119

      #3
      Solution/

      You can set the value using the AfterUpdate event of the Check Box. It can be done by macros or VB.
      Macros:
      Select the CheckBox --> Field Property Sheet --> Event --> Macro Builder --> Show All Actions. Now you use the SetValue action where the Item is the Name of the field you want to populate the Now() with, and Expression is Date().


      Regards,
      Ali

      Comment

      Working...