-
Cannot get memo Field in form to record data in table
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|