Append and Delete 1

[LuckieIrie]

Greetings, Is there a way to Append records to a table then Delete the records from the original table all with only one warning msg?

 

[Darrylles]

Hi,

Yes.

Regards,

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk

 

[JoanneM]

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
Darrylle may be a living example no less

LuckieIrie
to turn warnings of
docmd.setwarnings false

to turn them of
docmd.setwarnings true

hope this is what you meant

ignore Darylle probably to much cholcolate for that easter bunny

 

[LuckieIrie]

Thanks, That is what I was looking for.