From: Chris W on
Hi All

Having searched around, I have not yet found an answer to my problem, so
hopefully one of you experts out there will know the answer.

I have 2 userforms (F1 and F2). F1 is "shown" and the F2 is loaded at
document launch.

On my main multipage when I select the relevent tab, I show the F2 in modal
and work there.

When the user selects a tab on F2 which means transfering control back to
F1, I Hide F2 and control is passed to F1 where I process the code for the
relevent tab.

What is happening is that the tab is selected, BUT there are no controls at
all shown on the page. If I navigate away from the selected tab to another,
and back all is shown again.

Is there a way of doing this navigation so that the tab's controls are shown
in the first pass rather than mocing off the tab?

Many Thanks

Chris
From: Fumei2 via OfficeKB.com on
I am not following this. It sounds like when you selct a tab on F2, control
is passed to F1. If this is correct, why does it matter that controls on F2
are visible or not, since you are not even there?

I am missing something.

Gerry

Chris W wrote:
>Hi All
>
>Having searched around, I have not yet found an answer to my problem, so
>hopefully one of you experts out there will know the answer.
>
>I have 2 userforms (F1 and F2). F1 is "shown" and the F2 is loaded at
>document launch.
>
>On my main multipage when I select the relevent tab, I show the F2 in modal
>and work there.
>
>When the user selects a tab on F2 which means transfering control back to
>F1, I Hide F2 and control is passed to F1 where I process the code for the
>relevent tab.
>
>What is happening is that the tab is selected, BUT there are no controls at
>all shown on the page. If I navigate away from the selected tab to another,
>and back all is shown again.
>
>Is there a way of doing this navigation so that the tab's controls are shown
>in the first pass rather than mocing off the tab?
>
>Many Thanks
>
>Chris

--
Gerry

Message posted via http://www.officekb.com

From: Chris W on
Hi Gerry

Thanks for your reply.

Basically I have too many controls to fit on one user form (I get the out of
memory message), so I have split the main form into two, moving some pages of
information onto the second form.

I have designed the second form so that it looks exactly the same as the
main form, in so much as it has a duplicate set of tabs - the difference
being that for all the non-applicable tabs, there are no controls. This is
overlayed onto the main form when required so that as the user navigates
through the tabs as far as they are concerned they see no difference.

The problem is, when I need to navigate back to the main form(i.e. the user
has selected a tab on the second form where the controls reside on the main
form), I hide the second form and the first is now showing, but without any
controls visible until I navigate away from the selected tab
--
Regards
Chris


"Fumei2 via OfficeKB.com" wrote:

> I am not following this. It sounds like when you selct a tab on F2, control
> is passed to F1. If this is correct, why does it matter that controls on F2
> are visible or not, since you are not even there?
>
> I am missing something.
>
> Gerry
>
> Chris W wrote:
> >Hi All
> >
> >Having searched around, I have not yet found an answer to my problem, so
> >hopefully one of you experts out there will know the answer.
> >
> >I have 2 userforms (F1 and F2). F1 is "shown" and the F2 is loaded at
> >document launch.
> >
> >On my main multipage when I select the relevent tab, I show the F2 in modal
> >and work there.
> >
> >When the user selects a tab on F2 which means transfering control back to
> >F1, I Hide F2 and control is passed to F1 where I process the code for the
> >relevent tab.
> >
> >What is happening is that the tab is selected, BUT there are no controls at
> >all shown on the page. If I navigate away from the selected tab to another,
> >and back all is shown again.
> >
> >Is there a way of doing this navigation so that the tab's controls are shown
> >in the first pass rather than mocing off the tab?
> >
> >Many Thanks
> >
> >Chris
>
> --
> Gerry
>
> Message posted via http://www.officekb.com
>
> .
>
From: Chris W on
Gerry

Before you start digging around too much I found this post which covers my
problem so I will investigate this further

http://www.keyongtech.com/2267069-multipage-value-wont-change-page
--
Regards
Chris


"Chris W" wrote:

> Hi Gerry
>
> Thanks for your reply.
>
> Basically I have too many controls to fit on one user form (I get the out of
> memory message), so I have split the main form into two, moving some pages of
> information onto the second form.
>
> I have designed the second form so that it looks exactly the same as the
> main form, in so much as it has a duplicate set of tabs - the difference
> being that for all the non-applicable tabs, there are no controls. This is
> overlayed onto the main form when required so that as the user navigates
> through the tabs as far as they are concerned they see no difference.
>
> The problem is, when I need to navigate back to the main form(i.e. the user
> has selected a tab on the second form where the controls reside on the main
> form), I hide the second form and the first is now showing, but without any
> controls visible until I navigate away from the selected tab
> --
> Regards
> Chris
>
>
> "Fumei2 via OfficeKB.com" wrote:
>
> > I am not following this. It sounds like when you selct a tab on F2, control
> > is passed to F1. If this is correct, why does it matter that controls on F2
> > are visible or not, since you are not even there?
> >
> > I am missing something.
> >
> > Gerry
> >
> > Chris W wrote:
> > >Hi All
> > >
> > >Having searched around, I have not yet found an answer to my problem, so
> > >hopefully one of you experts out there will know the answer.
> > >
> > >I have 2 userforms (F1 and F2). F1 is "shown" and the F2 is loaded at
> > >document launch.
> > >
> > >On my main multipage when I select the relevent tab, I show the F2 in modal
> > >and work there.
> > >
> > >When the user selects a tab on F2 which means transfering control back to
> > >F1, I Hide F2 and control is passed to F1 where I process the code for the
> > >relevent tab.
> > >
> > >What is happening is that the tab is selected, BUT there are no controls at
> > >all shown on the page. If I navigate away from the selected tab to another,
> > >and back all is shown again.
> > >
> > >Is there a way of doing this navigation so that the tab's controls are shown
> > >in the first pass rather than mocing off the tab?
> > >
> > >Many Thanks
> > >
> > >Chris
> >
> > --
> > Gerry
> >
> > Message posted via http://www.officekb.com
> >
> > .
> >