Rabu, 09 Maret 2016

[MS_AccessPros] Help updating a record

Need help resolving updating a record containing the following fields: 4 comb-boxes bound 4 text boxes bound 1 checkbox bound 1 text box (memo) bound 1 text box (meno) unboundThe bound controls are associated to a table.The unbound field is used to concatenate text to existing data. An afterupdate event is used to do the concatenation and save the newmemo to the field bound in the other memo field.The issue is if the user changes one of the first three control typesand the unbound field. The afterupdate events fire in the proper orderbut the bound memo field displayes "Deleted!"When the record beforeupdate event fires an error message is displayed:

Write error The record has been changed by another user since you started..