Button Single click

[Smart]

I currently have a form with a button that once clicked displays a word document,however I have to double click on the button even though the code is on the single click event property.The only line of code is as follows
OLEFile.Action = acOLEActivate

Does any body know how I can get the single click to work ?

 

[ghudson]

Sounds like your form in question does not have the focus. Your first click is setting the focus to your form and the second click is hitting the OnClick event of your button.

 

[Smart]

Thanks for the reply

The button was on a sub form

When I tried to set focus to the button (forms!9form1]![subform]![field]
I received the error 2110 can't move focus
So coded for error 2110 and ignored it . I could then single click on the button

Thanks again