Displaying an Open Form

's Computer Specifications

What is the syntax to bring an open form to the front?

I have 2 forms open, and in some instances, I need to swap which form is in
front. I just can't seem to locate the correct code.

Any help is appreciated.

Sharkbyte

's Computer Specifications

On Sun, 15 Oct 2006 15:55:01 -0700, Sharkbyte
<(E-Mail Removed)-> wrote:

>What is the syntax to bring an open form to the front?

Not certain, but how about

Forms.formname.SetFocus

John W. Vinson[MVP]

's Computer Specifications

That did it. Thanks.

"John Vinson" wrote:

> On Sun, 15 Oct 2006 15:55:01 -0700, Sharkbyte
> <(E-Mail Removed)-> wrote:
>
> >What is the syntax to bring an open form to the front?
>
> Not certain, but how about
>
> Forms.formname.SetFocus
>
> John W. Vinson[MVP]
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open Form Displaying Records that Meet the Criteria selected	Bubu85238	Microsoft Access Forms	2	27th May 2008 04:40 PM
how to open single form displaying last (new) record	=?Utf-8?B?SmVmZg==?=	Microsoft Access Forms	2	1st Feb 2005 07:09 PM
Popup form not displaying controls, displays calling form that it is hovering over instead	=?Utf-8?B?U3VlIFRob21hcw==?=	Microsoft Access Forms	0	25th Jan 2004 03:56 AM
Click on record in a subform datasheet to open another form displaying info related to that record???	edself	Microsoft Access Forms	1	24th Nov 2003 07:28 PM
Click on a record in a subform datasheet to open another form displaying info related to that record???	edself	Microsoft Access Forms	2	24th Nov 2003 06:20 PM