Why is my form always in front?

[edowling]

Hi there folk. I've been using Access for years and I'm having a problem that I've never encountered before. Here's the gist of it:

I have a form that is my Switchboard. I've written and AutoExec macro to open and maximize the Switchboard when the database is first open. Several of the buttons on the Switchboard open different dialogue boxes that the user can use to choose a student name and then open another form (the enrollment form or encounter form) from there.

Here's the problem. When I choose a student and open the encounter or enrollment form from the dialogue box, it opens but is immediately hidden behind the Switchboard. Thus, my Switchboard form is always in front. This only happens with one of the button/dialogue boxes, not all three. Can anyone help me out on this, it's driving me crazy!!!

She who is beating her head on the wall,

Lis

 

[mkphan]

You can set the properties of the form to be opened to POPUP in the OTHER tab of the Properties dialog box.

MK

 

[edowling]

Yeah, I tried that already. My Switchboard is still in front... :-(

Any other ideas?

 

[LonnieJohnson]

Hate to sound redundant, but is the form that you are trying to OPEN set to Popup? If not, it will stay behind the last activated Popup window. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[edowling]

At this particular moment in time, none of the forms are set to Pop-up.

 

[gwinn7]

I believe I have encountered this problem before. Could you copy the entire code behind one of your command button's click event and post it (like the one in your example)? Do you have code in the Form_Lostfocus event? Post that too if possible.

Gary
gwinn7