Repeat fields from last record

[Ray67]

I have a form with many fields. For one of the fields i would like it to repeat last record but also have the option to leave it blank.
Example:


Ray Doe 01/01/2013
Jane Doe
Sandy Doe 01/01/2013

I found this code on online
Me.txtTransfer Date.DefaultValue = """" & Me.txtTransfer Date & """"

It repeats the last record but when i try to delete the record, i get this error

Compile Error:
Syntax error

Thank you

[RuralGuy]

Embedded spaces can be a problem. Either eliminate them in your names or try:
Me.[txtTransfer Date].DefaultValue = """" & Me.[txtTransfer Date] & """"

[Ray67]

Rural guy

You were right the space was the problem.

Thank you very much

[RuralGuy]

Glad we could help.