>It should work with
>
>RS2("Country") = RS1("Country")
>
>' or whatever value you want on the right
>
>BTW, I assumed you were populating the blank RS2 record on the left. If I read it wrong, change it to RS1("Country")
The original message indeed had a typo. I had already tried your suggestion this morning and the same error. It does not allow me to write to the recordset on the left. I even tried creating a new one (AddNew) and cloning an existing one. Same thing.
Even RS.("Country") = "OZ" gives the error.