allowing update/append but not delete for individual fields

[ray436]

Hi ....<br><br>I have tried various forms of permissions and locks in our database, but none seem to fit the bill.&nbsp;&nbsp;What I need to do is allow users to add more information in a &quot;memo&quot; type field, but not be allowed to remove what is there.<br><br>global permissions are no good since some fields need to be completely changed, while others need to have additions only.<br><br>Do I need to code this specifically for the field ?<br><br>Thanks in advance......<br>

 

[jimmythegeek]

Probably the safest way to do this is to add one more field (unbound) to your form. <br>Lock your original field. <br>The user can add new data in the unbound field, and on Lost focus of the field, you can concatenate the unbound field onto the end of your memo field.<br><br>For example:<br><br>Private Sub NewField_LostFocus()<br>&nbsp;&nbsp;&nbsp;Me.MemoFieldName = Me.MemoFieldName & &quot; &quot; & Me.NewField<br>End Sub<br><br>This way the user can see what is there, and add new data, but cannot touch the original.<br> <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development

 

[ray436]

Thanks Jim,&nbsp;&nbsp;works great, had to play with the synatx to get the behaviour just right, but that was particular to my one database.&nbsp;&nbsp;Placed the 2 fields right atop each other, now they look like one &quot;split window.&quot;<br><br>appreciated