Send Form Info to Different Table if Condition Holds

[jl2886]

I have two tables in Access, one that contains Active or Pending Policies and another table that contains Rejected policies. I have a form corresponding to the table with a certain variable called "Status" that evaluates whether a policy is Pending, Active or Rejected(a regular conditional statement in VB). The form is linked to the Active or Pending Policies Table currently, however, I would like the form information to send a policy to the rejected policy table if the "Status" variable value is Rejected and for it to send a policy to the Active or Pending Table if the "Status" variable value is Pending or Active. I am not neccessarily looking for the conditional statements to execute this command, rather I want to know the visual basic function that will do this, or to know if there is no such command and if I have to create another Form, Query or Table to do this.

[Rabbit]

You'll need a DoCmd.RunSQL "SQL Statement" that will append the record and then another one that deletes the old record.