appending a record using code..

[gbanks]

looking for code to append the current record only.. Thanks

 

[Fornatian]

Without asking you to expand, the only advice I can offer is that in your append query you make reference in the query criteria to the current record so that the query only pulls the data from the form.

Forms!MyForm!MyCurrentRecordPrimaryID

 

[belton]

What about seeking a record, and wanting to add only the values received by the seek to append one record? Any ideas?