using command buttons to archive single records

[vnfoster]

I know that this has already been presented, however I am really new to using VBA and don't entirely understand the suggestion. I want my users to be able to move a single record from an open table to a closed table, using a command button on a form.

Thanks

 

[MarkK]

Hello and welcome to the forum.
It is generally a make-work project to have two tables where records have the exact same structure but differ only by status. If this is your situation, consider adding a new field called 'Status' which may only take the values 'Open' and 'Closed'. Then your command doesn't move the record, it simply changes the data in a single field, which is much, much simpler.
And to return statistics across items that may be open and closed *poof* they're already all in the same table. Etc...
Cheers,