Has anyone seen or know how to trigger an objects
bring to front or send to back method
or is it even a method at all. I have an Access 2000 form
that I zoom sub tables on for improved usability, and I 
need to be able to Bring the zoomed object to front from VBA

I zoom the object by setting the subforms .top .height properties
using a flip flop flag so the button acts like a toggle.

It works great but one of my subforms goes over another, this is fine 
for one of these subforms but not the other. If I could trigger it to
send one to back when I zoom the other it would work perfectly,
right now the other subform hovers partially within the one I'm zooming.

Hope his makes sense, it should to anyone who has set these properties 
from code before.  

Thanks Brian Paniccia

Brian, How about hiding the subform you want to sendtoback?

Mark
----- Original Message ----- 
From: "Brian Paniccia" <briansigma@y...>
To: "Access" <access@p...>
Sent: Monday, January 27, 2003 8:53 PM
Subject: [access] How to BringToFront or SendToBack in code


> Has anyone seen or know how to trigger an objects
> bring to front or send to back method
> or is it even a method at all. I have an Access 2000 form
> that I zoom sub tables on for improved usability, and I 
> need to be able to Bring the zoomed object to front from VBA
> 
> I zoom the object by setting the subforms .top .height properties
> using a flip flop flag so the button acts like a toggle.

Why not just use .Visible property to show/hide required subforms, ie. 

My!MySubform1.Visible = True 'Display form 1
My!MySubform2.Visible = False 'Hide form 2

etc...



____________________________________________________


John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________


The doors we open and close each day decide the lives we live

____________________________________________________


CONFIDENTIALITY & PRIVILEGE NOTICE

>>> briansigma@y... 28/01/2003 7:53:51 >>>
Has anyone seen or know how to trigger an objects
bring to front or send to back method
or is it even a method at all. I have an Access 2000 form
that I zoom sub tables on for improved usability, and I 
need to be able to Bring the zoomed object to front from VBA

I zoom the object by setting the subforms .top .height properties
using a flip flop flag so the button acts like a toggle.

It works great but one of my subforms goes over another, this is fine 
for one of these subforms but not the other. If I could trigger it to
send one to back when I zoom the other it would work perfectly,
right now the other subform hovers partially within the one I'm zooming.

Hope his makes sense, it should to anyone who has set these properties 
from code before.  

Thanks Brian Paniccia




This message is intended for the addressee named
and may contain confidential information.

If you are not the intended recipient, please
delete it and notify the sender.

Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.