Apologies for not-very-informative thread title.  

Assume I'm doing data entry on a form that shows records from the Correspondence table.  Each record in Correspondence is the unique record of a given calender month/year's reporting for a specific organization.  The Organization table can be considered to be the parent table, linked by ProgramID to multiple Correspondence records which are specific to Year and Month.

A third table, Reports, is where the actual reporting figures go; insofar as each Organization may sent anywhere from 1 to 60 reports each month, Reports is a child table of Correspondence.

Visible on the Correspondence form are the ProgramID (brought forward from Organization), Year, Month, email subject line, DateReceived, and a button to which I haven't attached any useful functionality yet (that's where I'm stuck).

What I want the button to do is as follows:

Go to the Form that shows records from Reports.  Make a new child record there that is linked to Correspondence by CorrespondenceID.  Inherit (fill in) the ProgramID, the Year, and the Month (brought over from the Correspondence record I was sitting on when I clicked the button).

I should now be staring at the first of "n" Reports records I'm going to create here, on the Reports form.



I don't know whether I should attempt this as a vbscript or as a SQL query.  I'm unclear on how to make a SQL query do the navigation (landing ON the newly-created Reports record) or how to get visual basic to generate a record in the related Reports table.