Macro button on Form

[sw]

I would like to create a macro button on a form so that
when you press it the selected record that is being
displayed is moved into a different table and then deleted
from the form it was in.

Is there any code that I can set up on a command button to
do this?

Any help would be great - thanks!

 

[Steve Schapel]

sw,

You would need to make an Append Query, to add the selected data to
the second table. You can put an OpenQuery actio in your macro to run
this query. As for deleting it from the existing table, there are two
possibilities. You can make a Delete Query, and once again another
OpenQuery action in your macro. Or else you can use a
RunCommand/DeleteRecord macro action.

- Steve Schapel, Microsoft Access MVP