K
KLP34
I have a date field and a yes/no field. Is it possible to have the program
insert the current date when the yes/no field is checked?
insert the current date when the yes/no field is checked?
S
Stuart McCall
KLP34 said:
Insert the following code into the checkbox's AfterUpdate event procedure:
If Me.checkBox = True Then Me.txtDate = Date()
M
Mike Painter
Me.txtDate = Date()Stuart said:
else
Me.date = ...
' NULL or a date far in the future are options.
End if
Without the "else" the date will remain even if you uncheck the other field.
K
KLP34
Works like a charm! I am very grateful ... Thank You!
M
Mike Painter
Thanks should go to Stuart.
S
Stuart McCall
Mike Painter said:
Tell you what, you pat yourself on the back and so will I.
