Write conflict message

A

amiga1200

I have a form with 2 subforms visible, the top subforms has detailed
information on the item selected in the bottom subform, on the top subform is
am unbound name field which when double clicked bring up a new form to
enter/change the name, when it is closed, the data is passed back to the name
field, which has the dirty property set to false, when I then click in the
bottom subform, I get the Access write conflict error message.

Thanks
 
G

Gijs Beukenoot

From amiga1200 :
I have a form with 2 subforms visible, the top subforms has detailed
information on the item selected in the bottom subform, on the top subform is
am unbound name field which when double clicked bring up a new form to
enter/change the name, when it is closed, the data is passed back to the name
field, which has the dirty property set to false, when I then click in the
bottom subform, I get the Access write conflict error message.

Thanks
Click to expand...

Check the default-values and 'older' records that might have NULL in
that particular column.
 
Top