Hi All

I am trying to clone a previous records field value that happens to be
a date.  I'm having a problem with the value of the date.  It's
returning a value of 1, (1/1/1900)  what am I missing?

Here is the code I'm using:

If Me.NewRecord Then
  Me.RecordsetClone.MoveLast
  Me!dtmHireDate.DefaultValue = Me.RecordsetClone!dtmHireDate
End If

TIA
Ann

The .DefaultValue property is actually a string - thus you need to put the
dtmHireDate inside two #

    Me!dtmHireDate.DefaultValue = "#" & Me.RecordsetClone!dtmHireDate & "#"

You may need to look at the usage of this though. The .DefaultValues will
only come into affect after the next time you add a new record. Any record
you add before this will be using the old .DefaultValue.

Mattias J?nsson