How do I make sure the record is "SAFE" to only "UPDATE" the Notes field?

[cw via AccessMonster.com]

I use the following code to open a NOTES box & allow the user to add Notes to
a Record.
(Notes is a Memo field in the main Table)
------------------------------------------------------
On Error GoTo Err_Command89_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmNotesIP"

stLinkCriteria = "[ip_ID]=" & Me![ip_ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command89_Click:
Exit Sub

Err_Command89_Click:
MsgBox Err.Description
Resume Exit_Command89_Click
-------------------------------------------------

The problem I'm seeing is corrupted records in my main Table?
It seems that when I open my Notes form from my Continuous form I need to
"SAVE" the record so that it is not in "EDITING" mode? I believe the
corruption takes place because the record is being "EDITED" in 2 places? How
do I make sure the record is "SAFE" to only "UPDATE" the Notes field?

Any ideas would be much appreciated.
cw

 

[Tim Ferguson]

How
do I make sure the record is "SAFE" to only "UPDATE" the Notes field?

If you really can't just put a big text box on the original form, I would
use an unbound (dialog) form and use GetChunk and AppendChunk to send it
the original memo field text and get it back. That way you keep all the
record manipulation within the one form.

I've never had problems with memo field corruption, but I've read enough
here to know that it can and does happen. My experience suggests it's one
of those KISS things.

Hope that helps

Tim F