Am having trouble making a database perform some actions after the main meu form is in view, but before anything is enabled for the users to touch.

I have a routine that happily puts some data into a table in the database, but I want the users to be able to see what is happening by means of a label caption. All of this works if driven from a button on the form, but I want it to be automatic.

I have tried instigating this in the on load, on activate, on current events, but the form does not display until after all the processing has occurred. This seems at odds with all the MS help files.

HALP!!!!

You can do it in the form's "On Open" Event and place this at the top before your other code:


DoCmd.Maximize

or

Me.Visible = True

Hope this helps...

Thanks heaps. The visible = true works.

Wonder why the form doesn't become visible on its own?


Steve

You're welcome!

The best I can figure out is that it does not display until the form has finished loading or if the form is updated with VBA (or maybe a macro - I do not use macros so not sure).

I wouldn't expect you to use macros, neither do I. But I got seriously annoyed with Redmond when their descriptions of when events occurr do not seem to match the actuality.
Thanks for your time.

Steve.