Hi Guys/Girls
I am building a database and I have a checkbox called 'Issued' and I want this to insert the current date into the field 'Issued Date' when ticked and to remove it when not ticked, I have looked on here and online and tried everything I have found but none work......this is what I have just now.
Private Sub Issued_AfterUpdate()
If Me.Issued = -1 Then
Me.Issued_Date = Now()
Else
Me.Issued_Date = Null
Me.Issued_By = Null
Me.Issued_To = Null
End Sub
The reason I also have Else Me.Issued_By = Null and Me.Issued_To = Null is because I want these fields also to be black when its unticked.
Any help would be great thanks
Davie