Moving records between tables in MS Access

[adjacent]

I have two tables(a and b) in one access document. And in each table, I have a field[called status](look up field) having the options "Done" and "Done_s".
What I want to do is move the records having the [status] "Done_s" to b. This should be done whenever the change occurs. Is this possible?

I never used access before and google also does not provide an answer to this.

 

[256bits]

You can use the built in Microsoft Visual Basic.
Lesson 1, what better place to start.
http://www.functionx.com/vbaccess/index.htm