Button driving me crazy!! (1 Viewer)

Hello All,
I am using Access 2000. I currently have a form that has three buttons. The three buttons are:
cmdClickme = TransferSpreadSheet
cmdstep1exit = Quit Application
cmdReturnToMainMenu = Return to Main Menu

The purpose of the form is to allow the user either click the cmdClickme button to transferspreadsheet to C:\tblclientblank.xls or click cmdReturnToMainMenu to return to Main Menu.When the process is done another button shows up which allows the user to exit the application. The last button allows the user to return to main menu if the button cmdClickme is not depressed.

My problem is when the cmdClickme is depressed the TransferSpreadSheet works and the cmdstep1exit does show up but the cmdclickme with the cmdstep1exit. I would like the cmdclickme to be invisible however VBA says the cmdclickme has the focus. How can I correct this problem? Thanks in advance for your assistance or advice.

looks like cmdClickme is putting the focus on cmdclickme therefore remove the .SetFocus line from the code

If that don't work post the code behind cmdClickme

You cannot hide a control that has the focus. In the TblCwLoadscalesPc43 Click event, after the TransferSpreadsheet, you need to set focus to another control and then you can hide the TblCwLoadscalesPc43 button.

Me.cmdReturnToMainMenu.SetFocus = True
Me.cmdClickme.Visible = False