Access help

[watkid]

Hi aal

I am in the middle of creating a database in Access. I need to have 2 fields that update automatically from field 1. Field 2 takes information - Date - from field 1 and adds 365 and enters the date in it. Field 3 takes the date in field 2 and subtracts 60 days and enters the date in it. In filemaker, it was easy but I am having problems doing it in Access - Office XP version.

Thanks for looking and your help

Dave

[alunr]

Probably something like...

Change the OnLostFocus of the Form to something like this.

Private Sub StartDate_LostFocus()

[YearOn] = ([StartDate] + 365)
[PreviousDate] = ([YearOn] - 60)

End Sub

>> Edited by alunr on Monday 21st June 16:04