troubleshooting Question

Access 2003 Form - When checkbox checked enter current date in a field, when unchecked clear date.

Avatar of mlaurin
mlaurin asked on
Microsoft Access
5 Comments1 Solution1350 ViewsLast Modified:
In a form I have a checkbox named Available and a date field named AvailableDate.
What I need to happen is when the checkbox is checked - enter the current date into the "AvailableDate" field, when it is unchecked - clear the AvailableDate field.

I am attempting to do an AfterUpdate on the checkbox with something like the following (which of course does not work):

Private Sub Available_AfterUpdate(Cancel As Integer)
    If [Available] = Yes Then
    AvailableDate = (current date)
    If If [Available] =  No Then
    [ActualAvailable] = (clear date field)
End If
End Sub
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros