Does Anyone Have Any Suggestion?

Hi,

I'm building a database and here is what I'm trying to achieve:

I have a form which takes individual records and stores them in the table called Comments Draft. On the form, I have a Status combo box from which I can label each record as "Draft" or "Final".

When I select "Final" on the form, I would like to take the record and move it to another table, which I can call Comments Final and then create a query which would delete record in Comments Draft table.

or

When I select "Final" on the form, I would like to disable editing option for that record. In this case, I would not mind if the record stays in the Comment Draft table but I would prefer the first scenario I described above.

I've been playing with this for a while now and I'm able to label each record as draft or final in the Comments Draft table and I'm able to disable or enable editing for all records regardless if it is draft or final.

Does anyone have a suggestion on what I'm trying to achieve? I would greatly appreciate it.

Thank you,

-f