Copy a row

V

Vivi

Hello everyone,

Just another (dummy) question :)

How can you duplicate a row in a table, by just changing
its index number.

Regards
 
R

Rick B

You can't. if you change the index number, you change the index number.
There is no magic that tells Access when you change some value you want it
to create a new record. How would it know that you wanted to do that?

Rick B
 
D

Doug M

If you mean create another record with all the same values except the
index, and you're working in the table itself you can select the record,
Copy, then Paste Append.

Doug M
 
Top