I got the add and delete to work fine if the date is greater than the last one posted... but I'm having trouble coming up with clear logic on finding the date to actually split and insert the data.
Each new note is formatted as follows:
##/#?/####: AAA- BBB? vbNewLine
noteString(possibly any length of string)
vbNewLine & Form![frmMain[![Memo]
that way there is a break after each individual note. I'm looking for some built in code that would step through each character until it found a vbNewLine character.... Then I could simply pull the subsequent characters until I find ':'. That would give me the compare date and I could use that to determine the location of insertion. If I find it first I'll let you know how I came up with it. Otherwise any help is appreciated.
Is the vbNewline character the same variable representation of hitting the enter key? if so this might be a problem.