Date control

[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

 

[fredg]

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,
Leave the control unbound.

Code the CheckBox AfterUpdate event:

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