alter a boolean field from no to yes with VBA (1 Viewer)

[Lanser]

I use the following to send a .pdf to the required email and it works well, but is it possible to include a boolean yes/no field in the table that holds the data and change it from no to yes in VBA so I know when a record has been emailed?

Private Sub SendEmailToAssignedTo_Click()
    
    
        Dim strFilter As String
            strDocName = "IssueAlert"
            strFilter = "Id = Forms!frmAlarm!ID"
        
        DoCmd.OpenReport strDocName, acPreview, , strFilter
        
       Dim blRet As Boolean
blRet = ConvertReportToPDF("IssueAlert", , "T:\Issues\Issue_Alert_" & Forms!frmAlarm!ID & ".pdf", False, False)
        
        DoCmd.Close acReport, "IssueAlert"
End Sub

 

[pbaldy]

Sure; probably the simplest way:

CurrentDb.Execute "UPDATE TableName SET FieldName = True WHERE Id = " & Forms!frmAlarm!ID