>Hello, all!
>
>I have a form which has buffermode = 0.
>
>In the form's DE, I am using R_PRODR with the default for buffermode (1 = Use form's setting).
>
>When the command:
>
>
DELETE FROM r_prodr WHERE releasid = m.releasid>
>Is run by the users, they [sometimes] get error #1585, Update Conflict.
>
>R_PRODR is
NOT a view. Nor is it buffered in any way on this form.
>
>This form is the only one where this table is changed in any way.
>
>Why would SQL-DELETE'ing records from the table result in this error?
>
>- George
By chance, is this table the recordsource for a grid on this form? If so, this may be the cause of the problem. You mith try:
thisform.mygrid.recordsource = ""
delete from...
thisform.mygrid.recordsource = "mytable"
then you have to redefine all the ControlSource properties for the grid columns.
Mark McCasland
Midlothian, TX USA