"export" current record in form to another database

[jazuraff]

Good day,

Currently, I have a database situation in which I am working in one database with data. If this data does not belong in this database I need to be able to take specific fields from the record and insert it into either a new table in a different database I have, or have it copied to a blank form that would accept it. Any thoughts?

 

[Estuardo]

G'd afternoon Jazuraff,
If i have to choose between forms and tables, i choose tables, they're far easy to manipulate.
To export to a new table you can build a make-table query and the export the whole table in one go with the DoCmd.CopyObject
To do export to an existing table in other db you can use ADO/DAO and do it row by row

G'd luck