How do you have the date enter when a check box is selected?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database and I want when someone clicks on a check box for it
to enter the date in another field and I don't want that date to change
unless the check box is un-selected
 
in the after update event of the checkbox put the following code

if CheckBox = True then
OtherField = Date()
Else
OtherField = ""
End if
 
I am going to try this code, but I think the date will change from day to
day, but hopefully it will not I will have to wait and see what happens
tomorrow.
 
Back
Top