Unclick check box!

[smoothie2006]

Hello all,

I've created a database using Access 2003. One part of it has a check box which is linked to a blank field (a date), so that if I click on the box, today's date will appear on the space of the field. That part is fine.

Now I'd like to know if there's a way to delete the date in the field (from the table) when I unclick the check box, so that everything goes back to its pre-clicked state.

Please feel free to throw in some comments and advice. Many thanks.

Smoothie2006

[Megalog]

Sounds easy enough, this is how I do it.

You probably already have an OnClick event for this checkbox when you insert today's date, so modify it to fit the following:

Private Sub YourCheckBox_Click()
    If Me.YourCheckBox.Value = True Then
        Me.YourDatefield.Value = Now()       
    Else
        Me.YourDatefield.Value = ""    
    End If
End Sub

[smoothie2006]

Hey, thank you so much for your help! :)