I'm using Access 2010 and a MDB.
I have a login form that when the user completes successfully, calls a Splash Screen . I have to link a bunch of tables which may take a little time. I want the splash screen to stay up while this is done and then the form closes and a switchboard type form opens
The form just has a header and an embeded picture on it. No controls.
I have all control boxes off with no border.
I've been around and around on this. I first tried putting the link code in the LOAD, but of course, it links, then goes directly to the switchboard.
I tried placing the code in the Activate and Got Focus events (along with a msgbox to see if it fires) and it doesnt.
So I thought I would create another form frmOpeningInvisible and place the code in that form. I could call frmOpeningINvisible from my splashscreen. But I run into the same problem - where to place things.
I then tried placing a text box (both visible and invisible) on the Splash Screen thinking that would trigger a form Activate. Nope.
The text box gets focus before the form is displayed.
Where do I place the code?
Should I place it on another, invisible form and if so, where do I call that form?
Loosing hair by the handfull.