I hope someone can help me.
I've vreated a form that has 2 memo fields (one to input data and the other to store in a table)
when I click on teh cmdbutton it shows the data on the stored field however it doesn't record it on the table until I go on the table and manually input some data, then it works fine.

here is the vb code for the cmd button and the form's record source

Option Compare Database

Private Sub AssociateIDSelector_AfterUpdate()
Me.Requery 'display Notes for selected customer
End Sub

Private Sub PostNote_Click()
If Len(Trim(Me.NoteNew)) > 0 Then
If IsNull(Me.Notes) Then
Me.Notes = Date & vbCrLf & Me.NoteNew
Else
Me.Notes = Date & vbCrLf & Me.NoteNew & vbCrLf & Me.Notes
End If
Me.Dirty = False
End If
Me.NoteNew = Null

NoteNew = Null 'blanks out new note, since it was just appended to Notes entry
DoCmd.RunCommand acCmdSaveRecord 'forces record save

End Sub

Record source

SELECT tblRMAssociateNotes.* FROM tblRMAssociateNotes WHERE (((tblRMAssociateNotes.[Associate ID])=Forms!frmRMPostAssociateNotes!AssociateIDSelecto r));

thanks in advance