Gem og slet en post

Why dont you just have a column in the table which you could use to indicate that the record is "deleted".

Jeg skal gerne have de poster i  en ny tabel ( slette_medlemmer ) som bliver slette fra tabelen medlemmer og  det skal  forgå på form Medlemreg med en knap som gør dette. Så hvordan får jeg knapen til det ( først gem post og derefte slet post )

Make an append query which will look something like this.

INSERT INTO slette_medlemmer
SELECT medlemmer.*
FROM medlemmer WHERE medlemmer.ID = Forms!Medlemreg.ID;

ID needs to be cahnged to the primary key field in th etbale and which is very likely the name of the field on the form.

Name the query qryMakeBackup for example.

Now place a button on the form using the wizard. If you follow the wizard you can get the it to generate code which will delete the current record.

Now you need to modify the code so you first make a backup of it useng the query tyou just made.

Place a line of code in code which dletes the record. It needs to be before you delete.

DoCmd.OpenQuery "qryMakeBackup"

Jeg takke mange gang for det svar  det virke

super, og selv tak