Is this a trappable error?

[chrismcbride]

I have a form on my distributed database that has it's format changed based on certain record characteristics and I am getting a message or error (I am not even sure which it is). The message is

----------------------------------------------------------------------------------
<frmWhatever> 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 you or another user made?

* To save your most recent changes and discard the changes the other users changes or your previous changes, click Yes
* To save this version of the object with another name, click No

----------------------------------------------------------------------------------

Now I think (and I stress think!) that this is because certain controls on the form are locked or hidded based on one of the record values. If this is so then I need to find a way to trap this error. However, I have placed a trap in the Form_Error event, and the error or message was not caught. Does any one have an idea why I am getting it or how I might trap it?

TIA
Chris

 

[ghudson]

Is your code opening the form in design view and then closing the form? That might explain why it is trying to save changes to your form.

If not, can you post the code that is altering your form and maybe we can offer a solution.

 

[The_Doc_Man]

I sometimes run into that one myself. Haven't quite found out what changes are involved, but if I ever figure it out, I'll post my answer to you.

I'll tell you this - it only happens when I am in the form and at least one other person is in the same form, different record. It might have something to do with unbound fields that change characteristics, too.

Tell you what, try in whatever closes your form that you run something to re-initialize the form to whatever state it takes on initial form load, if that is possible. If not, then I'm not sure what to tell you.

 

[Rakier]

I too have received that message, but also when editing the design of a table. It won't save my design changes. It really is an irritating message.

Doc_Man...

I know that it is happening when noone else is using the dB because it has happened on a development database that noone else has access to.

I haven't been able to find any rhyme or reason to it as there are really no discernable commonalities to the situations when it happens.

Anyone?????

 

[chrismcbride]

Boy this is frustrating!
I am pretty sure that the Design changes it thinks it is finding are me programmatically hiding, enabling, showing and changing text in various bound and unbound controls. This is done based on if each record has it's 'approved' field set to true or false.

I have tried to trap the bugger in the form_error event but no luck. It seems to NOT be an actual error.

I definately have had this message without going anywhere near Design View. Today I opened one instance of the database, and then opened the form in question. Then opened a new copy of the database on another machine. Navigate around through various records and close the second instance. Then when I go to close the first instance, I get the error.

I have thought that the only way to avoid this is to remove the form and database close buttons. Then provide only one close button that I make. Then I can suppress the design message by either explicitly saving or not saving the form. Since I know that there are no actual changes, I should be OK. I suppose that I could also finally get around to splitting the db and giving a separte copy of the form. That should get me around it as well.

Just frustrating that I can't find a way to trap the error. That is the way this should be handled!

Thanks guys, and any other thoughts would be welcome!
Chris