Does anyone have any suggestion?

[fijufiic]

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

 

[Rabbie]

You don't actually need two tables for this - just have a status field for each record and then you can use a query to select the "Draft" ones and another query to select the "Final" ones.

 

[fijufiic]

Rabbie,

Thank you for your response.

I know that I do not need two tables for this which is described in the second scenario of my original post but I would like to somehow keep Final (& locked for editing) records separate from drafts.

-f

 

[Rabbie]

Then just use some VBA to move the record from 1 table to the other when you change the Status to Final

 

[fijufiic]

That's exactly what I need help with. If you do not mind being more specific since I'm not a VBA expert.