Archive record

[Martin]

Is there a way to archive a record from a form? For
example, I have a form that keeps track of users who
forgot their passwords, what I would like to happen is to
come up with some kind of command button that removes any
record I'm in and places it in a seperate table from my
main table, is this possible?

 

[Dan Artuso]

Hi,
The usual way to do this is to have an 'archive' field in the same table.
It's datatype would be boolean, so when you want to archive a record
you just that field to True.
The query that feeds your form would filter out those records where the flag is set.