copy all fields from a record to a different table

[sheckay]

Hello All,

I need to make a command button, in Access, to copy all the fields from a record that I am currently viewing to a different table. The second table, that will receive these records, is structured exactly like the table containing the records. And I would like for the records that are copied to the second table to not overwrite each other. Does anyone have any experience with this? Thanks in advance.

geoff

 

[Surjer]

You will want to write an append query. And run it with

DoCmd.RunSql "MyInsertSQL"

If you need help with the actual SQL then This has heaps of info - Start Here