When Date + 7 days then...??

pookie62

Registered User.
Local time
Today, 17:17
Joined
Jan 16, 2005
Messages
47
Hi,
I want to block editing certain fields after a date (+ 7 days)
This date exist on the form in the txtDatumFix field
Now I have this:
Code:
 If Forms![Inschrijving].[txtDatumFix] < Now() Then
   Me.AllowEdits = False
   Me.AllowAdditions = False
 End If

I want 7 days on top of the existing date (dd-mm-yyyy) then the block should start..
Anybody knows how to do this ???
Thanks for helping out..
 
Use the DateAdd("d", 7, Date) function in the forms OnCurrent event.

Code:
If Forms![Inschrijving].[txtDatumFix] < DateAdd("d", 7, Date) Then
   Me.AllowEdits = False
   Me.AllowAdditions = False
   Me.AllowDeletions = False
End If
 

Users who are viewing this thread

Back
Top Bottom