Here's a tough one. (At least I think so.)

I am using the DataGrid control with ADO. I have used the form wizard to create a form that has all those nifty buttons at the botton of the form (Add, Update, Delete, Cancel.etc). This is what I would like to accomplish. When the user clicks the 'Add' button on the form with the Datagrid, I display a message asking whether or not they would like to copy an existing record (as a template). If they select Yes, I display a form that has a list box where they can choose which record to copy from.

My question is this: How do I copy the current record that I am at from one form as the new record on the other form(the one with the DataGrid)? One other thing, I have a text box next to the list where they can give the new name of the record(so the key will be unique). How do I pass this with the copied record?

I know this is alot to digest and I'm sure I have left something out. Any suggestions?