Notes summary from text boxes

[demi4u]

I have a notes box on a calls form that has an associated date field for time stamping and a field for Initials of the person for the associated note, that keeps each note in the table by ID.. I want to have a summary page on the master form for the client that summarizes the notes in another memo control showing a scoll bar with the past notes. such as...

Can I concatenate the notes + Time + Initials + separation line for a summary on a form?

_________________________________________________
|------------------------------------------------------------------------|
| 7/22/2003 1:22:23 PM - DH - Phone call about conference |
| this call was good, i feel we got some where. |
| -----------------------------------------------------------------------|
| 7/23/2003 3:34:12 PM - JS - First meeting where Ipresent |
| The idea of first speculation. |
|------------------------------------------------------------------------|
________________________________________ ________|

-Dan Thanks for the help

 

[TheAceMan1]

How are ya demi4u . . . . .

Something like the following ([purple]you substitute proper control names[/purple]):

[blue]   Dim NL As String
   
   NL = vbNewLine & vbNewLine
   
   If Len(Me!Notes & "") > 0 Then
      If Len(Me!Memo & "") > 0 Then
         Me!Memo = Me!Memo & NL
      End If
      
      Me!Memo = Me!Memo & Me!Time & " - " & Me!Initials & " - " & _
                Me!Notes
   End If
[/blue]

See Ya! . . . . . .