Access 07 - Properties Sticking

[MightyAC]

I have recently started running some 2000 and 2003 format databases with Access 2007 and have noticed a few annoying issues. The one I'll discuss in this post is the fact that properties seem to "stick" or save in 07.

I've read quite a bit about filters saving on forms but I've had other properties save as well. For example I have several forms that I use for both data entry as well as record editing. I open them like this:

New Record:
docmd.OpenForm "FormName",,,,acFormAdd

Edit Previous Record:
docmd.OpenForm "FormName",,,"IDField = " & IDValue


Anyway, for some seemingly random reason every now and then after opening the form in acformadd mode the DataEntry property will be set to true and save that way. So later when I try to edit a previous record all I see is the new record screen.

To combat the problem I no longer use the default parameter and always specify either the acformadd or acformedit. (docmd.OpenForm "FormName",,,"IDField = " & IDValue, acFormEdit)

However, I would like to know what causes the form to save certain properties, every now and then and why.

Any ideas?

 

[RuralGuy]

How do you close your forms? Do you use DoCmd.Close acForm,Me.Name,acSaveYes?
If so, that could be a source of the problem since the acSaveYes is for saving changes to the FORM and not the RecordSource of the form.

 

[MightyAC]

Thanks for the reply...but no I'm not closing the form like that.

I also searched the entire project for the accidental inclusion of code like docmd.RunCommand acCmdSave

Like filters the property just seems to save itself on occaision.

 

[RuralGuy]

Let's root for some guru stopping by with a solution. Good luck. Sorry but that was the extent of my ideas.

 

[MightyAC]

Yeah that or a hotfix from Micro$oft.

 

[RuralGuy]

I knew I forgot something. Office 2007 has both a Service Pack and a HotFix. Are they both applied? Good catch MightyAC.

 

[MightyAC]

Yeah, I'm all up to date. However, when reading the hotfix page it specifically mentioned a problem setting specific printers in 07. I have another application that does that. In the event we start running that with A07 that bit of information will be usefull. thanks.