Getting the wrong date

[froggiebeckie]

Morning all.
I'm struggling with a data entry form.
After entering it one time, I'm trying to get the [Week Ending] date to carry forward to the next record(s), until I change it or have entered all my new records.

Based on info I received here, I put this code into BeforeUpdate property of [Week Ending]:
Private Sub Form_BeforeUpdate(Cancel As Integer)

Me.[Week Ending].DefaultValue = Me.[Week Ending]

End Sub
The date I get now is 12/30/1899.
Any idea why this is happening?

As always, thanks for taking the time,
BeckieO

 

[KenHigg]

I think you have to pound the date value...

Me.[Week Ending].DefaultValue = "#" & Me.[Week Ending] & "#"

But I'm not sure...


ken

 

[froggiebeckie]

That Did IT

That did the trick--Thanks a bunch.

BeckieO

 

[KenHigg]

Cool -


ken