Hi,
I'm getting a following message, always on the same page of tab control:

The data has been changed.
Another user edited this record and saved the changes before you attempted
to save your changes.
Re-edit the record.

I know that there isn't any other user working on database. What could be a
problem?
Thanx

alekmil

You are the other user. You have 2 different forms editing the same record.
Access has no way of knowing that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"alekm" <(E-Mail Removed)> wrote in message
news30C56A3-CD47-42DA-863D-(E-Mail Removed)...
> Hi,
> I'm getting a following message, always on the same page of tab control:
>
> The data has been changed.
> Another user edited this record and saved the changes before you attempted
> to save your changes.
> Re-edit the record.
>
> I know that there isn't any other user working on database. What could be
> a
> problem?
> Thanx
>
> alekmil

Seems to be quite reasonable, but I can't find out which record is edited by
two forms (subforms I guess)...

"Arvin Meyer [MVP]" wrote:

> You are the other user. You have 2 different forms editing the same record.
> Access has no way of knowing that.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.accessmvp.com
> http://www.mvps.org/access
>
>
> "alekm" <(E-Mail Removed)> wrote in message
> news30C56A3-CD47-42DA-863D-(E-Mail Removed)...
> > Hi,
> > I'm getting a following message, always on the same page of tab control:
> >
> > The data has been changed.
> > Another user edited this record and saved the changes before you attempted
> > to save your changes.
> > Re-edit the record.
> >
> > I know that there isn't any other user working on database. What could be
> > a
> > problem?
> > Thanx
> >
> > alekmil
>
>
> .
>

I've also noticed that when I edit subform with option buttons group and
than I jump to any other subform or tab, the whole form is being refreshed
(text boxes in forms header that are loaded with dlookup blink once). Why? I
can not find any event procedure instigating this.
Thanx

alekmil

"alekm" wrote:

> Seems to be quite reasonable, but I can't find out which record is edited by
> two forms (subforms I guess)...
>
> "Arvin Meyer [MVP]" wrote:
>
> > You are the other user. You have 2 different forms editing the same record.
> > Access has no way of knowing that.
> > --
> > Arvin Meyer, MCP, MVP
> > http://www.datastrat.com
> > http://www.accessmvp.com
> > http://www.mvps.org/access
> >
> >
> > "alekm" <(E-Mail Removed)> wrote in message
> > news30C56A3-CD47-42DA-863D-(E-Mail Removed)...
> > > Hi,
> > > I'm getting a following message, always on the same page of tab control:
> > >
> > > The data has been changed.
> > > Another user edited this record and saved the changes before you attempted
> > > to save your changes.
> > > Re-edit the record.
> > >
> > > I know that there isn't any other user working on database. What could be
> > > a
> > > problem?
> > > Thanx
> > >
> > > alekmil
> >
> >
> > .
> >

Using a form and subform to edit the same record, or page of records is a
cause. Depending upon the size of each record, there can be anywhere from 1
to several dozen records on that page. The moment you type a single
character, you lock the page.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley


"alekm" <(E-Mail Removed)> wrote in message
news:8A518EED-49EA-42CE-89A8-(E-Mail Removed)...
> Seems to be quite reasonable, but I can't find out which record is edited
> by
> two forms (subforms I guess)...
>
> "Arvin Meyer [MVP]" wrote:
>
>> You are the other user. You have 2 different forms editing the same
>> record.
>> Access has no way of knowing that.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.accessmvp.com
>> http://www.mvps.org/access
>>
>>
>> "alekm" <(E-Mail Removed)> wrote in message
>> news30C56A3-CD47-42DA-863D-(E-Mail Removed)...
>> > Hi,
>> > I'm getting a following message, always on the same page of tab
>> > control:
>> >
>> > The data has been changed.
>> > Another user edited this record and saved the changes before you
>> > attempted
>> > to save your changes.
>> > Re-edit the record.
>> >
>> > I know that there isn't any other user working on database. What could
>> > be
>> > a
>> > problem?
>> > Thanx
>> >
>> > alekmil
>>
>>
>> .
>>