Creating historical records from a form

[gal4y]

I would like to take the contents (record) of a form which displays the contents of conferences. The subfrom displays the people that will attend the conference.
This is a one to many relationship (conference to conference_coverage).

I would like to be able to send selected records to a table and delete specific fields (date, faculty).

Is this possible?
It sounds like a append/delete query but I would like to do it in a form so the user can send selected records to a historical table.

Thanks for any assistance
Greg

 

[PWise]

create a append query and a delete query in the date criteria put forms!formname!datetextbox (sub with actule names)
in a command button on click event put
docmd.openquery "appendqueryname"
docmd.openquery "deletequeryname"