------=_Part_8127_29625515.1206129230537
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On 3/21/08, Fred Parkinson <FredP@[EMAIL PROTECTED]
> wrote:
>
> But now and then a user re****ts a error (I have to translate):
> .. event before update caused an error:
> Update or CancelUpdate without AddNew or Edit
I've only seen this error in MS-Access when I've done one of two things:
I've tried up manually update or cancel an update to a record (in a
recordset object) that wasn't already opened for editing or opened as a
newly created record.
This should be the only way that this error message should be raised.
I would use the DEBUG find utility to search all of you form's code for
any instances where the DAO recordset methods are being used to update
your
form's recordset object.
I would bet that user is able to call one of these methods via the form's
control's event procedures at an unexpected time when the record has not
recieved any changed from the user.
Regards,
Richard Broersma Jr.
------=_Part_8127_29625515.1206129230537
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
<div><span class="gmail_quote">On 3/21/08, <b
class="gmail_sendername">Fred Parkinson</b> <<a
href="mailto:FredP@[EMAIL PROTECTED]
">FredP@[EMAIL PROTECTED]
>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid">But now and then a user re****ts a
error (I have to translate):<br>.. event before update caused an
error:<br>
Update or CancelUpdate without AddNew or Edit</blockquote>
<div> </div>
<div>I've only seen this error in MS-Access when I've done one of
two things:</div>
<div> </div>
<div>I've tried up manually update or cancel an update to a
record (in a recordset object) that wasn't already opened
for editing or opened as a newly created record.</div>
<div> </div>
<div>This should be the only way that this error message should be
raised.</div>
<div> </div>
<div>I would use the DEBUG find utility to search all of you
form's code for any instances where the DAO recordset
methods are being used to update your form's recordset
object.</div>
<div> </div>
<div>I would bet that user is able to call one of these methods via the
form's control's event procedures at an unexpected time when
the record has not recieved any changed from the user.</div>
<div> </div>
<div>Regards,</div>
<div>Richard Broersma Jr.</div>
<div> </div></div>
------=_Part_8127_29625515.1206129230537--
