Append input from one form to another

[AmyLynnHill]

Greetings,
I have a form(frmMainContacts) that has a field "notes". The form is attached to a table(tblMainContacts). I have tabs that have subforms,frmCalls set up in datasheet view. When the "notes" field is updated on the main form, I want it to send the note to the subform on a new line. Append the Note field information to the subform. I'm a new user of VB, I've tried to do this with an append query on the afterupdate event. However, it appends all the records in the main form and I only want it to append the record I'm on. Any suggestions?

 

[rainman89]

you need to specify in the append query what record you are on, so you can do

yourrecordID= "the recordID that you are on on the form"

This should only do the record you are on

 

[AmyLynnHill]

Thanks for the quick response. I must apologize for not understanding or not explaining well. Let me further explain.

I think I specified the record but not correctly. I have attatched a screen print of the query and the forms. The frmMainContacts form has a subform frmWithRequest, the tab "participant Calls" is a subform frmWithCalls, linked to the frmWithRequest subform by request ID, the Record source is the Calls Table.

At first I had the append query with forms![frmWithContacts]![PartNotes] in the notes field only. It appended one record to the calls table but didnt retain the SSN or request Id.....

Really appeciate the help.

 

[AmyLynnHill]

The attachment

 

[rainman89]

you can try using this link to give you more of a start as to referencing forms
http://www.mvps.org/access/forms/frm0031.htm

I think it has to do with the references within your subforms

 

[AmyLynnHill]

Thanks for all your help! you were right, the referencing was incorrect for the subform.