Form has changed error

sarahb845

Registered User.
Local time
Today, 03:09
Joined
Jun 19, 2002
Messages
43
Users are getting a "Form has changed" error when closing a form, even if all they did was look at data. There were no changes to the records, and they do not have access to make design changes. The database is split; both fe and be reside on a server. All users (approx. 10) have full rights to the location on the network where the database resides.

From my reproduction efforts, this is what is happening:
User 1 - Opens database.
User 1 - Opens form.
User 1 - Moves between records on form.

Meanwhile...
User 2 - Opens database.
User 2 - Opens form.
User 2 - Moves between records on form.
User 1 - Closes form. Gets the ERROR!
User 2 - Closes form. No error.

The error that is displayed is:
<Form> has been changed since the last time you opened it, either by another user or because another instance of it was opened on your own machine.

Do you want to replace the changes that your other another user made?
To save your most recent changes and discard the other user's changes or your previous changes, click YES.
To save this version of the object with another name, click NO.


The frustrating thing about this error is that the user either overwrites, or saves as a new form. There is no way for them to CANCEL, i.e. discard their changes, and leave the form as is. I don't want them to select NO b/c then there will be multiple copies of the same form in the database.

So, for some reason the database thinks that the FORM object (not data) has changed, even when no changes have been made.

What is going on here????? This is causing major headaches.

sarah
 
DoCmd.Close

I am wondering about this code:

Private Sub cmdClose_Click()
' Code for the Close Form command button located on bottom of form.

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Switchboard"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "frmEmployeeMaster"

End Sub


Should I include the acSaveNo at the end of the DoCmd.Close?
 

Users who are viewing this thread

Back
Top Bottom