Automatically insert date when other field is true?

[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?

 

[Stuart McCall]

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 following code into the checkbox's AfterUpdate event procedure:

If Me.checkBox = True Then Me.txtDate = Date()

 

[Mike Painter]

Insert the following code into the checkbox's AfterUpdate event
procedure:
If Me.checkBox = True Then

Me.txtDate = Date()
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.

 

[KLP34]

Works like a charm! I am very grateful ... Thank You!

 

[Mike Painter]

Thanks should go to Stuart.

Works like a charm! I am very grateful ... Thank You!

 

[Stuart McCall]

Thanks should go to Stuart.

Tell you what, you pat yourself on the back and so will I.