Date control

  • Thread starter Thread starter Chad Thompson
  • Start date Start date
C

Chad Thompson

I use several fields in a form that show a date when a
checkbox is clicked or "on". The control source that I
used for these was: =IIf([Complete],Date(),Null).
How do I get the date to stick to the day the box is
clicked and not change when the actual date changes?

Thanks,

Chad Thompson
 
Chad said:
I use several fields in a form that show a date when a
checkbox is clicked or "on". The control source that I
used for these was: =IIf([Complete],Date(),Null).
How do I get the date to stick to the day the box is
clicked and not change when the actual date changes?

Thanks,

Chad Thompson
Click to expand...
Chad,
Leave the control unbound.

Code the CheckBox AfterUpdate event:

If [CheckBox] = True Then
[AControlName] = Date
End If
 
Back
Top