This record has been changed by....

[rkdcomp]

I believe I've seen an answer to this, but a search can't find it. So here it goes!

I have a form based on a query.

When I change one certain field on a form based on the query and I try and close the form, I get the following Dialog Box Message.

"This record has been changed by another user since you started editing it." There is more and 3 buttons to select.

But the kicker is, this is a stand alone computer connected to nothing. So there is NO OTHER USER.

Now if I open the form, go to Design and the Query, run it and add the data to the offending field, close the Query and the data is in the form and I can close the form without geting message.

Driving me CRAZY!

Thanks in advance for any help.

Richard in Tulsa.

 

[RickSpr]

One thing that could cause this is if you have a second recordset open on the query or the underlying table, and you have modified the record via that recordset since the form was positioned to this record. (The first recordset is the one underlying the form itself.)

Is there any updating done to the table containing this field, other than by the form? It could be done through a Recordset processed in code by a form or control event, by QueryDef.Execute on an action query, by DoCmd.RunSQL, by calling a procedure in a standard module that does any of these, or by numerous other techniques. The code that does this could be in the form itself, in a subform, or in another form you have open at the same time.

Failing that, do you have another form or query open at the same time, in which you're updating something? Perhaps it's updating the problem row in a way you don't realize or intend.

If you've still got nothing, try changing the form's Record Locking property to Edited Record (it should be No Locks right now, if I'm not mistaken). That won't fix the problem, I don't think, but it should shift the error to the other place where the row is being updated. Rick Sprague

 

[rkdcomp]

Rick:

Thanks for the tips. I'll give them a try tomorrow. The form is opened from another from, but that form is just a one field form for record ID to query on.

I'am going top try and open the editing form on it's own and let it act as a parameter query and see what happens.

If that works, then I can't see why the input form is causing problems.

I may also change the control source to the original table and view all the records and change the one field and see what happens.

FYI: I also used a backup front-end just in case there was a problem with the front-end I ws using. It was no help.

I'll update this thread with what I find or don't find.

Richard