How to make a Database Form open

[rovman]

On Load is blank and in On Open I have built into it DoCmd.Maximize event. I have placed the DoCmd. Maximize event in On Load and then an Open Form Macro in On Open but still acts the same way.

[rovman]

I used Ac2007 User and Group Level Security.

[RuralGuy]

If you remove or comment out the maximize stuff does it still require the extra <ENTER> key?

[RuralGuy]

Is your form set as the Startup Form? http://www.btabdevelopment.com/ts/de...aspx?PageId=96

[rovman]

yes I clear the On open and Pn Load event and it still requires the additional step to open up the form

[RuralGuy]

Just so I'm clear, you said you get this same hesitation when you open the form directly from the development (database) window, right? Have you tried Compact and Repair yet?

[rovman]

yes you are correct. I just tried the compact and Repair and it did not make a difference.

[RuralGuy]

Any chance you can post your db? You may want to try *importing* everything into a fresh new db first. http://www.btabdevelopment.com/ts/impnew If that does not work then you could just import the one form and dummy data and see if it still has the same issue. If it does then post *that* db so we can look at it.

[rovman]

I will try importing the data to a new DB even if that works I will post it here for you to loom at. I am really interested to find out what is going on with it. I am sure it is something I overlooked.

[rovman]

Well importing the orginal DB into a new DB did the trick. it looks like something between 2002-2003 and 2007 did not like each other in the DB. But is working great now. thank you for all the help.

[RuralGuy]

Excellent! Thanks for posting back with your success and solution.