move byebye

[elmister]

Hello everyone, can a record be moved from one table to another when a certin dropdown selection is maked.
example: i have two tables one is called "stock" the other "sold" .
Both have the same fields "make" and "serial number".

A form with these two fields and a combo box that says stock and sold. when the info is entered or retrieved and the combo is set to sold can that record go to the sold table?

if so could i please have a example and will take it from there.
you guys are the genius in access and i thank you for the help.

 

[RuralGuy]

What you are describing is the same as archiving.

 

[missinglinq]

Multiple tables with identical fields is a big nono in relational databases! Can't pull up the link Allan gave you, but the usual way this is done in Access is to have a boolean (Yes/No) field in the record. If "sold" is selected from the combobox, the Yes/No field is set to "Yes." The query that is the basis for your form only shows records where the boolean field is set to "No."

So in the Combobox AfterUpdate event, the boolean field is set to "Yes" and the form is requeried, which eliminates records where the field is set to "Yes."