[RESOLVED] After email sent update recordset feild

[vonoventwin]

How do I update the strEmailsent feild after an email is sent?

DoCmd.SendObject , , acFormatTXT, stEmailAddress3 & ";" & stEmailAddress, stEmailAddress4 & ";" & stEmailAddress2, , stSubject, stText, -1
    rs!strEmailsent = True ' --this is a YES/NO checkbox feild
    rs.MoveNext

[Hack]

Use -1 unstead of True.

[vonoventwin]

Not working. Error Saying Update or Cancel update without Addnew or Edit

[Hack]

Not working. Error Saying Update or Cancel update without Addnew or Edit

Then you need to do an AddNew or an Edit on the recordset.

Is this VB or VBA?

[Frans C]

If it is a DAO recordset, you need to add rs.Edit before you change the value, and rs.Update afterwards.
If it is an ADO recordset you don't need the rs.Edit, but you still need the rs.Update.

[RobDog888]

Moved to Office Development forum.

[vonoventwin]

Hmm I am lost...

DoCmd.SendObject , , acFormatTXT, stEmailAddress3 & ";" & stEmailAddress, stEmailAddress4 & ";" & stEmailAddress2, , stSubject, stText, -1
    rs.Edit strEmailsent = -1
    rs.Update strEmailsent
    rs.MoveNext

[salvelinus]

DoCmd.SendObject , , acFormatTXT, stEmailAddress3 & ";" & stEmailAddress, stEmailAddress4 & ";" & stEmailAddress2, , stSubject, stText, -1
    rs.Edit 
    'this assumes you have a field in the rs called strEmailsent
    'If this isn't the actual name of the field, use the correct one
    rs!strEmailsent = -1
    rs.Update
    'you don't need .Movenext unless this is in a loop you didn't include in the post 
    rs.MoveNext

Hack, why use -1 instead of True?

[RobDog888]

Are you using a DAO recordset or a ADO one?

[vonoventwin]

DoCmd.SendObject , , acFormatTXT, stEmailAddress3 & ";" & stEmailAddress, stEmailAddress4 & ";" & stEmailAddress2, , stSubject, stText, -1
    rs.Edit 
    'this assumes you have a field in the rs called strEmailsent
    'If this isn't the actual name of the field, use the correct one
    rs!strEmailsent = -1
    rs.Update
    'you don't need .Movenext unless this is in a loop you didn't include in the post 
    rs.MoveNext

Hack, why use -1 instead of True?

This worked! I know what I want to do, but syntax kills me since I don't know anything about programming. Yes I have it in a Loop statement.