Update next record formula clarification

nick1408

Registered User.
Local time
Tomorrow, 07:40
Joined
Jun 16, 2016
Messages
77
I am using the following to update a field:

Code:
Private Sub RICT_Month_AfterUpdate()
If Not IsNull(Me.[RICT Month].Value) Then
  [RICT Month].DefaultValue = "#" & Me.[RICT Month] & "#"
End If
End Sub

1. How do I make it see the date as 1 August rather than 8 January?
2. When it carries over how do I make the default value after 1 August 1 September
3. How do I modify this to do the same for weeks (i.e. 1 August, the next default would be 8 August)

Thanks guys.
 
Code:
[RICT Month].DefaultValue = "#" & Format(Me.[RICT Month], "mm/dd/yyyy") & "#"
 

Users who are viewing this thread

Back
Top Bottom