Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, on a form I have a tick box and a field for a completion date. I would like the date field to auto fill with the current date when the tick box is set to yes and clear when not. what would be the best way of modeeling this?


    Many thanks, Darren.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='iksotof' post='767230' date='25-Mar-2009 12:32'][/quote]
    In the AfterUpdate event of the checkbox use the following code:
    Code:
    Private Sub Check0_AfterUpdate()
    If Me.Check0 = True Then
    	Me.Text2 = Date
    Else
    	Me.Text2 = ""
    End If
    End Sub
    Replace Text2 and Check0 with the names of your controls.
    Francois

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Francois

    Darren.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •