Not sure what the definition of easy is, but try this:
Declare a variable that is public to your form:
Public LastDate as Date
Then in the BeforeUpdate event set that variable to the value of the date
field.
Then in the OnCurrent event:
If IsNull(LastDate) or LastDate="" Then
Exit Sub
Else
YourDateField.value = LastDate
EndIf
Let me know if it works ...
Bill wrote:
My data base is a record of bank deposits by date. I update the table using a
form and I would like to automatically enter the next date by adding one day
to the previous record upon new record creation. Is ther an easy way to do
this ??
--
Message posted via
http://www.accessmonster.com