How to Insert a record into a Recordset 1

[Iainkerr01]

Hi

I am using a recordset to create an emailing system. Having written the email to the first of many recipients using a loop on the first recordset, I want to insert a confirmation to a second table with the date and email title, which is set up as a second recordset.

Can anyone point me in the right direction?

Many thanks

 

[jrbarnett]

You can either use

rs.AddNew
rs.Fields("Field1") = strValue
rs.Fields("Field2") = intValue
rs.Update

or use an SQL insert statement to add the value to the table.

CurrentDB.Execute "Insert into Fieldname (Field1, Field2) Values ('" & strValue & "', " & intValue & ")"

John

 

[Iainkerr01]

Hi John

You're a star!! I used the "Code" method and it works a treat. Vary many thanks for your prompt reply.

Iain