I was wondering if anyone knows how I can do this. What I would like to do is .... after selecting a record in my form (sign inventory) and subform (sign history), I would like to take the sign and its history I've selected and click a button/control and move the records to another table(s) in a seperate .mdb file. For example for archived signs, if the sign is archived, the sign and it's history do not need to be in the tables any longer but I want to keep an archive file by year of the archived data (ArchivedSignInventory2003 & ArchivedSignHistory2003 tables). Would it be possible to have a button to take the records and place them in the two archived tables in a seperate .mdb file from that form/subform?
I would appreciate anybody's expertise. Thanks!
I would appreciate anybody's expertise. Thanks!