View Single Post
  #2  
Old November 4th, 2008, 09:14 PM posted to microsoft.public.access.tablesdbdesign
tkelley via AccessMonster.com
external usenet poster
 
Posts: 150
Default automatic entry of previous record

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