Determine which form to be on top of the other

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michalis J. - 27 May 2008 21:41 GMT

If we have two forms and one report opened at the same time is there a way to
set programmatically at any time which form or report will be on top of the
other?

Reply to this Message

Dirk Goldgar - 27 May 2008 22:03 GMT

> If we have two forms and one report opened at the same time is there a way
> to
> set programmatically at any time which form or report will be on top of
> the
> other?

I haven't checked this, but I think you can use DoCmd.SelectObject to give
the focus to the object you want. If you want to get them all stacked in a
particular order, I imagine you'd have to select each one in turn, from
bottom to top.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Michalis J. - 28 May 2008 06:07 GMT

Thanks Dirk. I will try that and reply back.

> > If we have two forms and one report opened at the same time is there a way
> > to
[quoted text clipped - 6 lines]
> particular order, I imagine you'd have to select each one in turn, from
> bottom to top.

Reply to this Message

Michalis J. - 28 May 2008 06:58 GMT

I have tried this but the the form or report can not be selected from it's
open or load event when it is opened. In my case I have a base form (for
patient's details and history) from where I can open another form (for the
patient's special examinations) as pop up. From the second form by pressing
a button I get a report preview (for the partigular examination). This last
report to be on top of the other two forms I have to set it's pop-up property
to "yes". This works fine except that in pop-up mode (of the report) I can
not activate any toolbars. I thought that if I find another way to bring the
report on top of the other forms (the second form is a pop-up) without
setting its pop-up property to "yes" I can activate a toolbar in the report
preview.

> Thanks Dirk. I will try that and reply back.
>
[quoted text clipped - 8 lines]
> > particular order, I imagine you'd have to select each one in turn, from
> > bottom to top.

Reply to this Message