By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,255 Members | 2,575 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,255 IT Pros & Developers. It's quick & easy.

How to stop this popup msg ?

P: 15
I has a combo-box in the form, that after update event it keep on pop up below msg :

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

How can i stop this ?

Thanks for advanced.
Oct 12 '07 #1
Share this Question
Share on Google+
7 Replies

Expert 2.5K+
P: 3,072
Microsofts explanation is:

Is your form based on a linked table ?

Oct 12 '07 #2

Expert 2.5K+
P: 3,532
And maybe a peek at the combo-box's AfterUpdate event so we can see what it's doing.

Welcome to TheScripts!

Linq ;0)>
Oct 12 '07 #3

P: 15
My after update has below code : (No subform)

DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE [Temp-OrderHeader].* FROM [Temp-OrderHeader];"
DoCmd.RunSQL "DELETE [Temp-OrderDetail].* FROM [Temp-OrderDetail];"
DoCmd.RunSQL "INSERT INTO [Temp-OrderHeader] ( Type, ORDNO, SYSDATE, MODEL, SUBJECT, ORDDATE, ETA, REV, PACK, ETA2, REMARK1, REMARK2, REMARK3, REMARK4, REMARK5, REMARK6, Location ) SELECT OrderHeader.Type, OrderHeader.ORDNO, OrderHeader.SYSDATE, OrderHeader.MODEL, OrderHeader.SUBJECT, OrderHeader.ORDDATE, OrderHeader.ETA, OrderHeader.REV, OrderHeader.PACK, OrderHeader.ETA2, OrderHeader.REMARK1, OrderHeader.REMARK2, OrderHeader.REMARK3, OrderHeader.REMARK4, OrderHeader.REMARK5, OrderHeader.REMARK6, OrderHeader.Location FROM OrderHeader WHERE (((OrderHeader.ORDNO)=[Forms]![OrderDelete]![OrdInfo]));"
DoCmd.RunSQL "INSERT INTO [Temp-OrderDetail] ( ORDNO, LOTNO, PARTNO, CUSTPARTNO, SSNO, ESNO, SHIPQTY, HEADCODE, REMARK, REV,REASON ) SELECT OrderDetail.ORDNO, OrderDetail.LOTNO, OrderDetail.PARTNO, OrderDetail.CUSTPARTNO, OrderDetail.SSNO, OrderDetail.ESNO, OrderDetail.SHIPQTY, OrderDetail.HEADCODE, OrderDetail.REMARK, OrderDetail.REV, OrderDetail.REASON FROM OrderDetail WHERE (((OrderDetail.ORDNO)=[Forms]![OrderDelete]![OrdInfo]));"
DoCmd.SetWarnings True
Me.Detail.Visible = True

Please have an advice for me to block the popup msg .... thanks.
Oct 17 '07 #4

Expert 2.5K+
P: 3,072
Is your form with the combo perhaps bound to Temp-OrderHeader and/or Temp-OrderDetail ?

Oct 17 '07 #5

P: 15
Yes it is bound to order header
Oct 18 '07 #6

Expert 2.5K+
P: 3,072
Hmm, then you have a problem when deleting and inserting rows as the form is bound to the table(s) you're manipulating.
One option is to manage the delete and insert before showing the form.
Can't you place the code "behind" the button that's opening the form?
That way the "fresh" data is already in place when the form opens.

Oct 18 '07 #7

P: 15
Thks for the advice, i hav find the reason why it popup by disable or remark the
delete temp table in cancel button.

So by doing that when user select the order it won't pop up that msg again.

Thanks again n hav a nice day ya. =)
Oct 19 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.