How to copy a record

[Al R]

Can anyone plese tell me if there is a way to copy a
single record or multiple records from a form into a
duplicate database. Except that the duplicate database
will be empty of records. The form is based on a query
that is based on a table.
Thanks

 

[Jim/Chris]

Add a command button that runs an append query
The append query would be based off the original table with
the record id coming from the existing open form or
whatever criteria that you selected for the records on that
form.

 

[Pavel Romashkin]

You can't copy enything from a form, because a form is nothing more than
a window to the underlying data.
You can, however, copy the contents of the underlying query anywhere you
want using an INSERT INTO query (called Append query in Access).
You can also do it in VBA, but it might be faster if you simply used a
Make Table query in the same database, then moved that table to the new database.

Pavel