If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I programatically bring a form to the top?
Hi All,
If I have a number of forms open on top of each other, how can I use VBA to make any specific one on top of the rest? Regards, Max |
#2
|
|||
|
|||
How can I programatically bring a form to the top?
Max,
That isn't the way to do it. Over lay one or more forms on top of each other and set their visible properties, like this: SubForm1.Visible = True SubForm1.Visible=False Where SubForm1 and SubForm2 re[resent your Subforms. Try this with a button using the OnClick event. SubForm1.Visible = Not SubForm1.Visible SubForm2.Visible=Not SubForm2.Visible In designview of the main form, set the Visible property of SubForm1 to Visible = True and SubForm2.Visible = false. The Button will toggle between the subforms. God Bless, Mark A. Sam "Max Moor" wrote in message . 16... Hi All, If I have a number of forms open on top of each other, how can I use VBA to make any specific one on top of the rest? Regards, Max |
#3
|
|||
|
|||
How can I programatically bring a form to the top?
take a look at DoCmd.SelectObject in VBA Help.
hth "Max Moor" wrote in message . 16... Hi All, If I have a number of forms open on top of each other, how can I use VBA to make any specific one on top of the rest? Regards, Max |
Thread Tools | |
Display Modes | |
|
|