Access 2003 to 2007 issue - double-click behaves differently

[iosborn]

Hi
In Access 2003 code in the double-click event of a control opens a new form
and sets the focus to the new form. However in Access 2007 the same code
opens the new form, but then the focus goes BACK to the calling form, which
is not what the application is supposed to do.
I have tried various VBA work arounds to no avail, has anyone else come
across this problem and come up with a solution?
Thanks in advance

 

[boblarson]

What code are you actually using?
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[iosborn]

Thanks.
I've taken it back to basics.
Use the following code in Access 2003 in a double-click event of a locked
but enabled control on Form1
DoCmd.OpenForm "Form2"
The mini app behaves as expected. Now upgrade it to an accdb (Access 2007).
You will now find that the focus is taken back to the calling form to
highlight the text in the control whose double-click just fired.
However I have found if you create the scenario from scratch in Access 2007
the behaviour doesn't occur (which isn't very useful as upgrade path)