REPOST: "The Data Has Been Changed." error (Btn Main Form & Subfor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question regarding the error message box of “The data has been
changedâ€. I have a form that has multiple tabs. The 1st tab contains main
form
information while the 2nd tab and 3rd tab have two different sub forms. The
problem is that if I change something in the 1st tab and then go to the 2nd
or 3rd tab (the subforms) and change something, the following error message
box pops up:

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

I have found that if I refresh the form after I change something on the 1st
tab, the error message would not appear when editing the subforms. However, I
really do not like the refresh feature. And, users have been complaining
that they DO NOT want to click any button when moving between tabs.

I have tried the following commands and it didn’t work (error message pops
up):
1) RunCommand acCmdSaveRecord
2) Me.Dirty = True
3) Me.requery

Thanks for answering the questions. :) Thanks*10000
 
questionnaire said:
I have a question regarding the error message box of "The data has
been changed". I have a form that has multiple tabs. The 1st tab
contains main form
information while the 2nd tab and 3rd tab have two different sub
forms. The problem is that if I change something in the 1st tab and
then go to the 2nd or 3rd tab (the subforms) and change something,
the following error message box pops up:

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

I have found that if I refresh the form after I change something on
the 1st tab, the error message would not appear when editing the
subforms. However, I really do not like the refresh feature. And,
users have been complaining that they DO NOT want to click any button
when moving between tabs.

I have tried the following commands and it didn't work (error message
pops up):
1) RunCommand acCmdSaveRecord
2) Me.Dirty = True
3) Me.requery

Thanks for answering the questions. :) Thanks*10000
Click to expand...

Sounds like you have two subforms both editing the same record in the same
table. Why would you do that? As far as Access is concerned that IS the
same as two different users trying to edit the same record.
 
Does the main form, or two subforms are bounded to the same table, it doesn't
have to be the same sub form, but it can happen if one of the sub forms is
bounded to the same table as the Main form
 
Back
Top