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

 

[Darrylles]

Hi,

At some point on this form, I would call another form formB (hidden, never seen by user), that takes the records from form A and store them to the historical table.

FormA should first compose a SQL string to be used by formB as it's datasource (or RecordSource), pass it to formB, formB then runs an append query based on data on the form.

Alternative is VBA within formA.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk