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.
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.