aytee111: Thank you, with the modified code, it somewhat works. But the date is not updating in the corresponding rows in the table.
The ":" was automatically populating in the code. I tried deleting it and rewriting the code many times. It didn't go away until the code was modified:
Code:
Private Sub cboExportStatus_AfterUpdate()
If Left(Me.cboExportStatus, 4) = "Yes" Then
Me.txtAvailtoSend = Now()
ElseIf Left(Me.cboExportStatus, 3) = "No" Then
Me.txtAvailtoSend= ""
ElseIf Left(Me.cboExportStatus, 12) = "Yes-Reroute" Then
Me.txtAvailtoSend= Now()
ElseIf Left(Me.cboExportStatus, 2) = "" Then Me.txtAvailtoSend = ""
End If
End Sub
pbaldy: thanks, researching the formats and slowly learning about them.
Thank you both again