Copy Record and change a field value

[TimTDP]

In Access 2000 I have a table called tblProduct". Apart from other fields it has a field called "ProductType

I want to copy the entire record and in the process change the value of ProductType. ProductType is part of an index so it cannot be duplicated.

What is the easiest method to do this?

 

[Remou]

I think an append query would be the best bet.

Insert Into tblProducts (This, That, ProductType) Select (This, That, 2) From tblProducts Where ID=7