Pop Up Form Focus Question

I have a form with the pop-up and modal proerties set to yes. The pop-up
form contains a list box of names and, when the user double-clicks a name on
the list, a report opens using the information from the list box as criteria.
As it stands now, the pop-up form stays on top of the report and it is very
difficult to read.

I would like the report to have the focus when it opens. Then, when the
user closes the report, the pop-up form will regain focus and they can select
another name or close the pop-up form.

Is this possible?

You will need to set the pop-up to non-modal. You can't move focus off a
modal form.

Bonnie
http://www.dataplus-svc.com

AccessIM wrote:
I have a form with the pop-up and modal proerties set to yes. The pop-up
form contains a list box of names and, when the user double-clicks a name on
the list, a report opens using the information from the list box as criteria.
As it stands now, the pop-up form stays on top of the report and it is very
difficult to read.

I would like the report to have the focus when it opens. Then, when the
user closes the report, the pop-up form will regain focus and they can select
another name or close the pop-up form.

Is this possible?

--
Message posted via http://www.accessmonster.com

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

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm


"AccessIM" wrote:

I have a form with the pop-up and modal proerties set to yes. The pop-up
form contains a list box of names and, when the user double-clicks a name on
the list, a report opens using the information from the list box as criteria.
As it stands now, the pop-up form stays on top of the report and it is very
difficult to read.

I would like the report to have the focus when it opens. Then, when the
user closes the report, the pop-up form will regain focus and they can select
another name or close the pop-up form.

Is this possible?

As I stated in my first post, in the code where you are opening the report,
just place the line of code:
Forms!NameOfYourForm.Visible = false

I will not matter that the form is set to Popup and Modal, the report will
then be visible and the form will not be in front of it.

Now, also in the On Close event of your report, you need the line:
Forms!NameOfYourForm.Visible = true

To again make the form visible. Using this, you can have the user provide
info in your form, open the report, close the report and then the user can
provide different info on the form and again open the report.


-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm


"bhicks11 via AccessMonster.com" wrote:

You will need to set the pop-up to non-modal. You can't move focus off a
modal form.

Bonnie
http://www.dataplus-svc.com

AccessIM wrote:
I have a form with the pop-up and modal proerties set to yes. The pop-up
form contains a list box of names and, when the user double-clicks a name on
the list, a report opens using the information from the list box as criteria.
As it stands now, the pop-up form stays on top of the report and it is very
difficult to read.

I would like the report to have the focus when it opens. Then, when the
user closes the report, the pop-up form will regain focus and they can select
another name or close the pop-up form.

Is this possible?

--
Message posted via http://www.accessmonster.com

.