dublicate report

Hi.

I have a VB 6.0 small application. First the user can create new record or
open existing record. I have a search form that asks the user for the
report number or title of the record. then the record is listed on ListView
which then can be selected to open report or record with command button.

I would like to add one command button that can be able to duplicate the
record and yet assign new record number.

can anyone help me accomplish this? please?

I am using access 2000 with dao recordset.

thanks



.