Date control

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
 
F

fredg

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
 
C

Chad Thompson

Thanks Fred, this worked great for me.
-----Original Message-----
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
--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
.
Click to expand...
 
Top