Write Confict

[Molly]

I have a form that has code to print copies of a one line label. the alpha
numeric fields in the attached table are start, end, copies and printdata.
the data is 3 char followed by 5 numeric.

anyway in the code I have a dataset.edit..... .update

when the form is closed I get a Write conflict message with save record,
drop changes, copy to clipboard options. I would like the code to save
changes to the record without the message. Any ideas?

Molly

 

[John Vinson]

I have a form that has code to print copies of a one line label. the alpha
numeric fields in the attached table are start, end, copies and printdata.
the data is 3 char followed by 5 numeric.

anyway in the code I have a dataset.edit..... .update

when the form is closed I get a Write conflict message with save record,
drop changes, copy to clipboard options. I would like the code to save
changes to the record without the message. Any ideas?

The write conflict is arising because you're apparently trying to edit
in code the very same record that you're currently editing on the
Form. Why? You already have the record open for editing right there on
the form; why the dataset Edit?

If it's to put a calculated value into a field, you can have a textbox
on the form (it can even be invisible if you wish), and use your code
to set the value of that textbox rather than opening a Recordset.