By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

select form on the background

P: n/a
TTD
Hi,

I have a form (formA) which is maximized. On that form I have a button which
opens formB in restore-mode. But when I leave formB, I don't get formA
maximized on the foreground, but it's the switchbox which is showed in
maximum.

Is there a command where I can select a form which is stil open on the
background?

Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Add this to the on close event of form B

Private Sub Form_Close()
DoCmd.Maximize
End Sub

--
Reggie

www.smittysinet.com
----------
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...
Hi,

I have a form (formA) which is maximized. On that form I have a button which opens formB in restore-mode. But when I leave formB, I don't get formA
maximized on the foreground, but it's the switchbox which is showed in
maximum.

Is there a command where I can select a form which is stil open on the
background?

Thanks in advance.

Nov 13 '05 #2

P: n/a
TTD
Thanks for reaction Reggie,

but I already did this. Problem is that when the form (formB) closes, I woul
expect formA te be in front again, but it's the switchbox that appears
maximized. So I'm looking for a command to select the windows from formA to
get back to the forground again.

"Reggie" <no**********@smittysinet.com> schreef in bericht
news:-7********************@comcast.com...
Add this to the on close event of form B

Private Sub Form_Close()
DoCmd.Maximize
End Sub

--
Reggie

www.smittysinet.com
----------
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...
Hi,

I have a form (formA) which is maximized. On that form I have a button

which
opens formB in restore-mode. But when I leave formB, I don't get formA
maximized on the foreground, but it's the switchbox which is showed in
maximum.

Is there a command where I can select a form which is stil open on the
background?

Thanks in advance.


Nov 13 '05 #3

P: n/a
When you open formB I aasume you aren't closing formA so that formA is still
loaded. If so try this

Private Sub Form_Close()
Forms!formA.Form.SetFocus
DoCmd.Maximize
End Sub

If formA is closed and you want to re-open it when formB closes

Private Sub Form_Close()
DoCmd.OpenForm "formA", acNormal
Forms!formA.Form.SetFocus
DoCmd.Maximize

End Sub
Hope this helps!

--
Reggie

www.smittysinet.com
----------
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...
Thanks for reaction Reggie,

but I already did this. Problem is that when the form (formB) closes, I woul expect formA te be in front again, but it's the switchbox that appears
maximized. So I'm looking for a command to select the windows from formA to get back to the forground again.

"Reggie" <no**********@smittysinet.com> schreef in bericht
news:-7********************@comcast.com...
Add this to the on close event of form B

Private Sub Form_Close()
DoCmd.Maximize
End Sub

--
Reggie

www.smittysinet.com
----------
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...
Hi,

I have a form (formA) which is maximized. On that form I have a button

which
opens formB in restore-mode. But when I leave formB, I don't get formA
maximized on the foreground, but it's the switchbox which is showed in
maximum.

Is there a command where I can select a form which is stil open on the
background?

Thanks in advance.



Nov 13 '05 #4

P: n/a
TTD
Thanks,

good tip, works fine....
"Reggie" <no**********@smittysinet.com> schreef in bericht
news:-a********************@comcast.com...
When you open formB I aasume you aren't closing formA so that formA is still loaded. If so try this

Private Sub Form_Close()
Forms!formA.Form.SetFocus
DoCmd.Maximize
End Sub

If formA is closed and you want to re-open it when formB closes

Private Sub Form_Close()
DoCmd.OpenForm "formA", acNormal
Forms!formA.Form.SetFocus
DoCmd.Maximize

End Sub
Hope this helps!

--
Reggie

www.smittysinet.com
----------
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...
Thanks for reaction Reggie,

but I already did this. Problem is that when the form (formB) closes, I

woul
expect formA te be in front again, but it's the switchbox that appears
maximized. So I'm looking for a command to select the windows from formA

to
get back to the forground again.

"Reggie" <no**********@smittysinet.com> schreef in bericht
news:-7********************@comcast.com...
Add this to the on close event of form B

Private Sub Form_Close()
DoCmd.Maximize
End Sub

--
Reggie

www.smittysinet.com
----------
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...
> Hi,
>
> I have a form (formA) which is maximized. On that form I have a button which
> opens formB in restore-mode. But when I leave formB, I don't get formA > maximized on the foreground, but it's the switchbox which is showed in > maximum.
>
> Is there a command where I can select a form which is stil open on the > background?
>
> Thanks in advance.
>
>



Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.