Code for appending a single record from one table to another table

[FRAZ]

What is the most efficient method to append a single record into another table. I've tried using an append query but it appears to append more than just the single record. The appended table is to be displayed on a subform.in the past I would simply find the record, and do a set value macro and then requery the sub form.any input Is helpful

[BluffMeAllIn]

HI Fraz,

I would think if you are using an append query and it is appending more than a single record then you have not identified unquely in the query the record that you want appended into the new(other) table.

If this were using vba code, which doesn't look like it is based on using append queries and macros, then there are multiple ways it could be done via coding using sql or standard dao.recordsets. I am rusty on the non-programming functions of access but would think perhaps the append query should work well but must be issues in the criteria of the query for it to take more than a single record.

Perhaps you could provide some further details regarding the specifics of the records, the append query and such to be able to provide further feedback.

Thanks,
Dave

[Missinglinq]

...Perhaps you could provide some further details regarding the specifics of the records, the append query and such to be able to provide further feedback...

You might also explain why you're doing this. Appending a Record from one Table to another is generally a violation of normalization and thus inappropriate.

Linq ;0)>