Access Macro help(Append,Delete Query)

Hi, here is the situation

I have a table with a list of clients.
this information is viewed on a form
what I want to happen is,
when a person is on a specific record,
if the closeAccount button is pressed,
those records are moved from the current table to closedAccounts table.

what I have right now is this,
I have a query that will ask for the client number and then move that data into another table.
I have another query that will ask for the client number and then delete the data from the current table.

my problem here is that I when a person presses the close account button, I want access to grab the current record being browsed and then accordingly Append and delete the data.

There are multiple tables that contain the client data, so entering the client number again and again is very annoying and also tedious....

Rather than worrying about the record number, try setting a flag when your control is pressed. ie update a new record field, boolean, to true. Then any record that is true is deleted and append as you require and join or select on the record number at that time

cheers
Rk