Repost - Strange Form Behaviour

[Guest]

Hi. I posted this over a week ago and received no replies, so here's a retry.
Thanks for any help.

I have a problem whereby a form opens, then is immediately minimised to the
task bar but only if I start the sequence from a Tab Control form. I'll use
made up form names to keep this simple.

OK - first, what works (ignoring the Tab control form). I open form1 and
select a value in a combo, then click a command button. This closes form1 and
opens form2, showing a list of records as per the combo selection. I click on
a command button on this form and it opens Outlook with the 'To' window
populated as per the combo selection. That's it - all of this works perfectly.

Now, what goes wrong. When the database is opened by the Users, a large Tab
Control form appears and this is the main 'switchboard' for the mdb. One tab
contains a subform on which is a command button that calls up form1. When I
click this command button, form1 appears correctly in front of the tab
control form. I make a selection in the combo and click the command button.
form 1 disappears but this time the tab form reappears with form 2 minimised
on the task bar.

Why does form 2 not appear in front of the tab form and how can I make it do
so? (The sequence continues OK if I pull up form 2 from the task bar).

Thanks, JohnB

 

[Guest]

In the Activate event of Form2, either maximize or restore your form,
depending on how you want it presented:

DoCmd.Maximize
or
DoCmd.Restore

 

[Guest]

Thanks for this.

I'll try it later when I get to the office - I'm on late shift today. I'll
reply again then.

Cheers, JohnB

 

[Guest]

Hi again.

I've tried adding both of your suggestions to form 2's 'On Active' event,
with no change. Did you mean me to do that? I think that's what you meant by
"In the Activate event of Form2...".

Perhaps you could correct me or suggest an alternative.

Thanks for the help, JohnB

 

[Guest]

Sorry to bombard you but I've just noticed that using Maximise in the On
Active event of form 2 has no effect but using Restore causes form 2 to open
behind the tab form - form 2 and the tab form are shown in cascade layout. I
didn't see this at first. Is there a way to get it to open fully in front of
the Tab Control form - just like form 1 does?

Thanks, JohnB