Pop Up Form Question

[AccessIM]

I have a form with the pop-up and modal properties set to Yes. The form
contains a list box of names. When the user double-clicks on one of these
names, a report opens up using the name in the list box as criteria. This
all works great.

However, the pop-up form keeps the focus and remains on top of the report
making it hard to read. I would like for the focus to switch to the report
when the name is double-clicked so that the report is in front. Then when
the report is closed, the pop-up form regains the focus so they can either
select another name or close the pop-up.

Is this possible?

 

[Klatuu]

A Modal Dialog will do exactly what you are experiencing.
What I would suggest is you make a small design change. I expect your
report is filtering based on the value of the List Box. In this case, the
form has to remain open so the report can find the value.

Instead, use the WHERE argument of the OpenReport method to pass the
selection and close the form. Then in the Close event of the report, open
the form again.

 

[Keith Wilby]

A Modal Dialog will do exactly what you are experiencing.
What I would suggest is you make a small design change. I expect your
report is filtering based on the value of the List Box. In this case, the
form has to remain open so the report can find the value.

Instead, use the WHERE argument of the OpenReport method to pass the
selection and close the form. Then in the Close event of the report, open
the form again.

I would respectfully make one minor deviation from that approach, I would
set the form's Visibility to False and then, when the report closes, set it
back to True. That way any user inputs will remain on the form in case they
need to re-run the report with a minor alteration to the filter criteria.

Regards,
Keith.

 

[Mr. B]

Dave,

This same poster has posted this same question at least two other times and
I have posted a solution to both of the previous postings. I don't know if
the OP cannot get back to his tread for some reason or what is going on, but
I do hope he will eventually get the solution he seeks.

here is one link to the other posts:
http://www.microsoft.com/office/com...=en-us&dg=microsoft.public.access.forms&fltr=

Here was my original suggestion:
Set your popup form to not visible when you open the report.
me.visible = false

Then in the On Close event of your report, set the popup form back to
visible.
forms!NamOfForm.Visible = true

Setting the form to not be visible will still allow the report to be visible
and the form will no longer be in the way.

WOW, there are more than one way to do many thing.
-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm