Form Loosing Focus

[Guest]

I have a form displaying information gathered from a Query. Once the client
is happy with the info it gets transferred to an Excel spreadsheet.
My problem is the form looses focus and change to the excel spreadsheet. I
would like to keep the focus on the form until all data is transferred.
A text box on the form will advice the client when done.
I have used the SetFocus command in my VBA script as well as on the "On
LostFocus" [Event Procedure] of the form without success.
Any help, ideas will be appreciated

 

[Penguin]

How are you transferring the data to Excel? If you are using code
please post the code. If using a macro explain your steps.

Then someone can help.