Hi All
I have a small problem with one of my forms....I have a form which a user picks a option from an drop "1" and the form puts todays date in the box, which is just what I need but........the date changes every day, so I want is to lock the date to the date the option was picked, I have enclosed the SQL below as I am sure it is somethink I have missed.
If Me.ToDoStatus14 = 1 Then
Me.ToDoDoneDate14 = Date
Thanks :-)