I have a form which saves a record to a table and this works fine. however when you press save and close i get two popups saying "Forms!DataEntryDrawingNumbers!List94" and then the same again saying List 85 at the end. however when I added DoCmd.SetWarnings False after the code previously behind the save and close button it seemed to suppress these pop ups. however then someone else tried to use this database on a computer that runs windows 7 versus windows xp on my computer they appeared again.
would this have any affect on my code. if not what do you think the problem could be?
Thanks ahead of time.
This is the code behind my save and close button
On Error GoTo Err_close_form_Click
DoCmd.SetWarnings False
Dim stDocName As String
DoCmd.RunCommand acCmdRefresh
RunCommand acCmdSaveRecord
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
stDocName = "AddNewRecordtoDrawingList"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "DeleteTempDrawingRecord"
DoCmd.OpenQuery stDocName, acNormal, acEdit
stDocName = "update drawing number"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SetWarnings True
DoCmd.SetWarnings False
DoCmd.Close
Exit_close_form_Click:
Exit Sub
Err_close_form_Click:
MsgBox Err.Description
Resume Exit_close_form_Click