Hi. I have a form containing one variable [SHPD] which is set up as a YES/NO type and another variable [DATSHP]which is a date type. Upon clicking the SHPD checkbox on the form, I want the current date to be entered in the DATSHP field. Similarly, when the checkbox is unchecked, I want nothing or all zeros entered in the DATSHP field. Currently, I have the following event procedure set up on the SHPD variable:
Private Sub SHPED_AfterUpdate()
DATSHP = Date
End Sub
How do I go about clearing the date when the box is unchecked? Any help is greatly appreciated.
Private Sub SHPED_AfterUpdate()
DATSHP = Date
End Sub
How do I go about clearing the date when the box is unchecked? Any help is greatly appreciated.