Access 2007 hsa added a nice function that allows you to record notes using a memo field and appendonly and two fields Comments (this is where you enter the note) and txtComments (this is where the history appears). This can be seen in many of the Access templates call Call Tracker.
A glitch of sorts though is when a person's note is only viewable in the history field (i.e. txtComments field) after a form is closed and reopened i.e. there is no "add note" command button or similar that allows an individual to see that their note has been entered into history in real time. Another issue is that when you reopen the form, the last comment entered into the txtComments field is still there. I tried to set the value of the Comments field to null on form close but then that added a timestamp to the history field.
Can anyone think of suggestions about how to get around these things?
I know this isnt the right code but I want to do something like
OnClick of command button or AfterUpdate (which ever can be done)
If Not IsNull(Me.Comments) Then
Me.txtComments.Requery
Me.Comments.Value = Null
End If
So basically what happens is that where a person enters a note, and then clicks the button (or moves away from field) the txtComments field adds the new note to the history, and then sets the comments field to null. But because the field is now null, nothing will happen on form close (i.e. the null note wont be appended to the txtComments field.