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)
"boblarson" wrote:
> What code are you actually using?
> --
> Bob Larson
>
> Tutorials at http://www.btabdevelopment.com
>
> __________________________________
>
>
> "iosborn" wrote:
>
> > 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
Similar Threads
