Copy command

C

CAM

Hello,

I have form that is bounded by a table called Inventory and what I want to
do is to push a command button that will copy a record from the Inventory
table and paste it into another table called Audited with the same identical
fields. How do I do that. Any tips will be appreciated. Thank you in
advance.

Regards,
 
T

tina

well, you can do that - but it's unusual to move records from one table to
another in Access. suggest you add a field to the Inventory table, named
Audited. if you simply want to track whether or not a record has been
audited, make the field a Yes/No data type. if you want to know *when* the
record was audited, make the field a Date/Time field. if the record may be
audited multiple times, you can forego the Audited field and instead create
a child table called tblAudited, using the primary key of tblInventory as a
foreign key in tblAudited. then add an AuditDate Date/Time field to
tblAudited - one record for each instance that an inventory record is
audited.

hth
 
Top