Strange behavior in Access 2007
I have an access application that is used in both Access 2000 and Access 2007, as most of the ones here at work are...
We are getting some strange behavior in one particular app that is just being built. We Have some code that fires in the load event of a form...but it is not firing in Access 2007 until the form is closed...maybe even when it is unloaded. I have tried it on two Office 2007 machines and it happens on both.
Head scratch...
We are getting some strange behavior in one particular app that is just being built. We Have some code that fires in the load event of a form...but it is not firing in Access 2007 until the form is closed...maybe even when it is unloaded. I have tried it on two Office 2007 machines and it happens on both.
Head scratch...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Unfortunately (for me) the steps to reproduce, don't reproduce it. Attached is the db I made following the instructions in the article... but it doesn't happen in this db in either Office 2000 or 2007... grrr.
...but it is happening with mine. At least I can look into the hidden form issue as the cause and see if I can work around it. It's odd, because I have used hidden forms, etc in other apps without this occurring... so there must be some other missing link to the problem.
test-db1.mdb
...but it is happening with mine. At least I can look into the hidden form issue as the cause and see if I can work around it. It's odd, because I have used hidden forms, etc in other apps without this occurring... so there must be some other missing link to the problem.
test-db1.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the tips. I tracked my problem down to something entirely different as the culprit. I have a subform on this form in detail section and I was hiding / unhiding the detail section in sections of the form code instead of hiding / unhiding the subform control itself. Once I made the change, it works fine. Not sure what is related to what in this case... but moving on...
I cannot reproduce the problem either and concur with Jeff. Suspect it's an issue with mixed versions. Using 2003 format from a 2000 executable is without a doubt questionable.
ASKER
It works fine in Office 2000. ?
I just found this link:
http://bytes.com/topic/access/answers/199175-load-event-active-form-fires-when-access-closes
Nice to know I am not going crazy. This is the same exact problem.