Keeping form on top

[Formulaoneman]

I have a switchboard which loads a sub form. When I click a button on the sub form, the focus goes back to the switchboard, and stays there. I want to keep the focus on the sub form throughout the entire process, and only go back to the switchboard when the sub form is closed.

How do I do this?

 

[missinglinq]

What is the purpose of this 'subform' What exactly does this button do?

Linq ;0)>

 

[Formulaoneman]

What happens is the Switchboard loads the subform (frmCreate). The sub form has several dropdowns which allow you to select Quarter, Year, Product line, State etc. The user then clicks a button which executes Access VBA code. This VBA application interacts with Excel (which has its own VBA code imbedded in it) and produces spreadsheets that present the data.

What happens is after the user clicks on the "Start" button, the focus goes back to the Switchboard, and stays there until after the VBA is complete. You have to click on the sub form tab in Access to bring it back to the top. If the user watches the Excel spreadsheet being populated (you have to have an instance of Excel open, or the application abends), the focus stays in Excel after the VBA is complete (the application saves/closes the spreadsheet, and the focus is on a blank Excel screen).

What I want is for the focus to stay on the frmCreate sub form throughout the VBA execution (and go back to frmCreate from Excel after if the user is watching it).

Thanks for replying, and I hope this gives enough information.