Fill in form header based on subform

[VictoriaAlbert]

I have a main form with several pages that are filled with subforms. On the main form is a header, with some key information that I want displayed once entered in a subform.

To be more specific, I have a subform where users can enter notes about a customer, and those notes are recorded as a memo field data type. Once those notes are written in the subform, I want them to appear in a "Customer Notes" box in the main form header.

I tried Autofill with a combo box, but I ran into two problems. One, I don't want the user to have to select on the combo box, I want the notes to just appear. Two, the notes are saved as a memo, so combo box would not even let me select it. Would I do an After Update event on the Notes subform? If so, what would the code be? I am very new to programming. Also, what would I have as the Control Source for the text box in the Form Header?



Any help would be greatly appreciated.

[kennejd]

On your main form header, do you want to display the most recent note from the subform? Or the note from the current subform record?

If tied to the current subform record, on the on current event of the subform, try:
me.parent.[notefield] = me.note. After parent, that might be a ! instead of '.'.

If you want the last related customer note, you can try a dlast function in the control source of the note field on the main form.