Transfer record

[tspies85 via AccessMonster.com]

Hi,
How can i do this...
I need to delete certain record (when i click the delete button) in the main
table. But at the same time the record about the deleted item will be
transfer to another new table which only consist of the details about the
deleted item.So, in the main table, it will consist of only active item. My
point is to make sure all the details about the deleted item will be at the
same table. If this need to be code...please help me because i'm not expert
in coding..thanks

 

[Arvin Meyer [MVP]]

The easiest (and in my opinion, best) way to handle this is to not delete at
all, but to mark the item as Inactive with a yes/no field. Then use a query
to display all the records where the Inactive field = false. Now you still
have the record, but only see it if you run a query to show inactive
records.

The only reason for a second table is to maintain an audit trail, where
records are continually being edited.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[tspies85 via AccessMonster.com]

Thanks Arvin,
i get the idea..but.what if i need to display in my form the list of the
active item only. do i need to write in code that only active=true will only
display in the form. can you give me the idea on how to write the proper code.
thanks..

 

[Arvin Meyer [MVP]]

Use a query with a where clause as in:

Select * From MyTable Where Active = True;
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com