How do I make a macro or some other function that allows user to choose any
row from a database which is then automatically cut & pasted to another
pre-speficied table (which acts kinda like an archive)?

I think Append query best solution for this. first make a select query, make
it show rows you need based on selection criteria and then change it type to
append query, specifying destination table

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Sutemi" <(E-Mail Removed)> wrote in message
news:85829050-AAFD-4227-AE7B-(E-Mail Removed)...
> How do I make a macro or some other function that allows user to choose
> any
> row from a database which is then automatically cut & pasted to another
> pre-speficied table (which acts kinda like an archive)?