Sorry I have a hard time following along what you're trying to do with all the field names that mean nothing to me.

So in general, not sure what you want to do if documentsdairy is null, so I just threw the current date in

IIF(IsNull(DocumentsDiary),Date(),DocumentsDiary+7)

For the second part, you just want to have an afterupdate event that sets the date.

If Date() - DocumentsDiary <= 7 Then ' something to catch so can't spam the date up if you change the combo box on accident
'do nothing
Else
  DocumentsDiary = DocumentsDiary + 7
End if

Sorry my question wasn't clear.

For the [casephase] field, I have a combo box where I can select the phase such as Case Intake. When I change that field to "Post Settlement Documents" to populate the [CasePhase] field from the Combo Box, I want the [DocumentsDiary] date field to be seven days in the future or seven days from today.

Something like if the CasePhase is currently "Case Intake" and today i change to "Post-Settlement Documents" i want the DocumentsDiary date field to show 8/23/2021.

Here is the combo box row source for [CasePhase]: "POST-SETTLEMENT DOCUMENTS";"INTAKE AND PREPARATION";"NEGOTIATIONS";"NEGOTIATIONS - SUSPENDED";"AWAITING POLICY ISSUANCE";"CLOSE CASE"

Does my question make sense?

Thanks,

John





When the

Is this what you need? Add to AfterUpdate Event for your ComboBox.

   If CasePhase = "POST-SETTLEMENT DOCUMENTS" Then
      If IsNull(DocumentsDiary) Or DocumentDiary = "" Then
         DocumentsDiary = Date() + 7
      Else
         DocumentsDiary = DocumentsDiary + 7
      End If
   End If

Ah, yea what Kevin has there should work.

Depending on how you use things I would probably still add a catch in there like I had (or similar, million ways you could do it) so if you set it to post-settlement documents, and then come back to it a few days later and accidentally change that combo box or re-set it back to post-settlement documents you don't end up adding 7 more additional days to it.