Copy Record to other database before clearing some fields?

[brettatexplace]

I have a form that displays a record, and it has a "clear" button on it. When the "clear" button is pressed, I wish to secretly copy the entire record to an identically structured database (using VBA), and then clear most fields displayed on the from to null. ie. Everytime the clear button is pressed, the other database will get a copy of the original record, thereby accumulating all changes to the current database that is displayed with the form.

I know how to clear everything, but what VBA would allow me to simply copy the record, then select the other database, do a paste, then get me back to my current form?

Thanks to all in advance!!!!

 

[fredericofonseca]

what database are you using?

in many of them a simple insert into will work, but you may need to use linked servers or linked tables.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[brettatexplace]

Sorry, it is Access2002