'Saving' is deleting a record ???

[sd100]

I have a database that has been working fine, but seems to have delevoped a glitch.

I have a control button that sets a number of fields part of which is:

ElseIf [PolicyType] = "aaaaaaa" And [Company] = "bbbbbbb" Then
[POLICY CATEGORY] = "ccccccc"
[POL CAT ID] = "3"
[RET AGE LABEL] = ""
[VAL NOTES AUTO] = "This is a Bond numbered " & [ddddd] & " taken out via bbbbbbbbb."

It all works fine - except for one field [VAL NOTES AUTO] when I click the control the fields are updated correctly. HOWEVER when I SAVE or CLOSE the form I get the message "Record is deleted" and the contents of that one field is deleted. It's driving me mad as this worked fine for ages. The only change I have made is to add another of these control buttons to another page (form) so the user can update fields from either place.

Any ideas??

 

[The_Doc_Man]

Is the field in question part of a single table or is the form bound to a JOIN query and that field is in a different table?

That answer makes a huge difference in how we would interpret the error.

 

[sd100]

It's part of a single table.

I've managed to get around the problem by removing the reference to (VAL NOTES AUTO) from the original control button, and creating a new button just to update this field. This works fine.