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
"CAM" <alex_martinez[ at ]comcast.net> wrote in message
news:eYtQoaD5GHA.4196[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text] > 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,
>
>
|