Access 2007 tabbed document format. How do I bring an already open form to front
Posted on 2009-02-12
I am using Access 2007 tabbed document format.
I open 2 forms using a macro at startup shall we say, FormA & FormB and as Form B opens last it then has the focus and is 'on top' of screen.
The forms are split forms based on different but linked data. They remain on the screen at all times and I can access each by clicking on the appropriate tab
What I would like to do is click on a button on FormB to bring FormA to the front, positioned at a particular.
I have tried using FormA.SetFocus in the onClick event of FormB's button but this doesn't bring FormA to the front
What am I missing here?
Both forms are opened at first by running a macro, they are both non-modal, non-dialog and so have no reason to hold precedence but I just can't seem to get the other form to come to the fore.
I am comfortable(ish) with vba so please feel free...
Any help as ever, gratefully received