Form Loosing Focus

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top