Dave 14867
Registered User.
- Local time
- Yesterday, 17:41
- Joined
- Jan 1, 2017
- Messages
- 56
Hello,
I am trying to calculate a date in a table based on another that has been entered already, essentially the expiration date is always 1 day later that it was made. What I want is for the WaterIntExpDate to be calculated as 1 day after the WaterIntLot date after it is entered. I have tried the code below but I get errors.
Can someone please help me out.
Private Sub WaterIntLot_AfterUpdate()
Me.WaterIntExpDate = DateAdd("d", 1, Me.WaterIntLot)
End Sub
Thanks
Dave
I am trying to calculate a date in a table based on another that has been entered already, essentially the expiration date is always 1 day later that it was made. What I want is for the WaterIntExpDate to be calculated as 1 day after the WaterIntLot date after it is entered. I have tried the code below but I get errors.
Can someone please help me out.
Private Sub WaterIntLot_AfterUpdate()
Me.WaterIntExpDate = DateAdd("d", 1, Me.WaterIntLot)
End Sub
Thanks
Dave