I am trying to make the end_date of my field in a form into the start_date of the next record.
Therefore in the afterupdate property of end_date I have written some code:
Me!start_date.defaultvalue = Me!end_date
I was hoping that each time the end date was updated the start date default value would be set to this. Therefore when I go into a new record surley this should work??
Basically what is happening is that the value reads 30 Dec 1999. Not sure why it is displaying this value. No matter how many different dates or ways I try to do this the next record always displays 30-Dec-99.
Please help!
Therefore in the afterupdate property of end_date I have written some code:
Me!start_date.defaultvalue = Me!end_date
I was hoping that each time the end date was updated the start date default value would be set to this. Therefore when I go into a new record surley this should work??
Basically what is happening is that the value reads 30 Dec 1999. Not sure why it is displaying this value. No matter how many different dates or ways I try to do this the next record always displays 30-Dec-99.
Please help!