Archive record

  • Thread starter Thread starter Martin
  • Start date Start date
M

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?
 
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.
 
Back
Top