How to stop this popup msg ?

[chinfk]

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
record."

How can i stop this ?

Thanks for advanced.

[nico5038]

Microsofts explanation is:
http://support.microsoft.com/kb/302492

Is your form based on a linked table ?

Nic;o)

[missinglinq]

And maybe a peek at the combo-box's AfterUpdate event so we can see what it's doing.

Welcome to TheScripts!

Linq ;0)>

[chinfk]

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]));"
Me.Requery
DoCmd.SetWarnings True
Me.Detail.Visible = True
Me.Type.SetFocus

Please have an advice for me to block the popup msg .... thanks.

[nico5038]

Is your form with the combo perhaps bound to Temp-OrderHeader and/or Temp-OrderDetail ?

Nic;o)

[chinfk]

Yes it is bound to order header

[nico5038]

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.

Nic;o)

[chinfk]

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. =)