Duplicating record, selected fields only

[wanderanwills]

Hello,



Is it possible to duplicate a record with selected fields, to be copied into a new record. ie if there are 10 fields, i only need 8 of them (no need for timestamp field etc form existing record)

Regards
Stephen

[CJ_London]

yes - you need to use an insert query. How you do this depends on whether you are using vba behind a button on a form or running a query etc.