I have a button in Access that copies one record and then saves it in the same table.
MsgBox "Re-Evaluation Created", vbInformation, ""
The table is called Initial_Eval, and the field is called Eval_date.
I want to change the date by 1, thus increasing the day. I'd like to add a command in the above script to change the date by 1 using the DateAdd.
What's the best way to do this?
So far I have:
Dim DateX As Date
DateX = Dlookup("Eval_date", "Initial_Eval","")
But I'm not even sure that's right, and I know I need to re-store the value after modifying it.