Autopopulate field

[SantasLittleHelper]

Is it possible to have a field on a form automatically display the current date when a tick box is ticked?

e.g. There is a tick box to show whether someone has sent a package out to a customer. When the 'Package Sent' tick box is checked, I would like the 'Package Sent Date' to display the date in which it was ticked.

 

[bugmonsta]

In my code I have kept the default names (checkbox1 and textbox1)

It will also empty the textbox should you untick the option, this is code against the tickbox

Private Sub CheckBox1_Click()
    If CheckBox1.Value = True Then
    TextBox1.Value = Format(Now, "dd/mm/yyyy")
    ElseIf CheckBox1.Value = False Then
    TextBox1.Value = ""
    End If
End Sub

 

[bugmonsta]

Just got to a machine with Access (2010) and tried the code above, changed fieldnames slightly to match my test file and it works - woohoo!

Option Compare Database

Private Sub Field1_Click()
If Field1.Value = True Then
Text1.Value = Format(Now, "dd/mm/yyyy")
ElseIf Field1.Value = False Then
Text1.Value = ""
End If
End Sub

 

[mole999]

i did think the idea was only to capture the date for the tick box, so
check if date is empty, if not exit sub as it has been previously updated
check for a tick and if it exists then add the date for now value and exit sub, therefore it should only complete once and never be changed