Current Date probs

[retrieve]

Hey,

I am using a macro (sorry!) to set the current date in a date field when a check box is ticked.

The date field is being filled in but with a date in the 1800s!...

I've used =Date() to set the current date.

Any ideas,

cheers,
CJ

 

[daveUK]

Try using the following code instead of the macro;

Checkbox_AfterUpdate

If Me.NameofCheckbox = true Then
Me.NameofTextBox = Date()
End If

I can't see any reason why you should get the 1800's date from the macro, but see if the code makes any difference.