Is this possible in Access???

[cmiturbe]

I have to create a button in a form or some way that will redirect a record/row to a resolved table and then remove/hide that record once the issue has been resolved. Also I saw the check box control and when I added that if I click the check in one record it checks the check box in all records. Can anyone help me with these issues? Thanks!

[cmiturbe]

I need the original record to be hidden not the redirected record in the resolved table.

Ex: BPOL Table: 3 records and one becomes resolved.
Resolved Table: 1 new record once BPOL record became resolved

Updated BPOL Table: 3 records but only 2 visible. 1 hidden-redirected to resolved table

[TheShabz]

This sounds like a "help ticket" table. I dont think you need 2 tables for this. One table with an added "Status" field should suffice.

BPOL Table:
Key, Data, Status
1, abc, Open
2, bcd, Open
3, cde, Open

Let's say record 2 has been worked on and resolved. You would run a query:
UPDATE BPOL
SET Status = "Closed"
WHERE key = 2

Now when you want to view all open records, you run the query:
SELECT *
FROM BPOL
WHERE Status = "Open"