If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pop Up Form Question
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? |
#2
|
|||
|
|||
Pop Up Form Question
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. -- Dave Hargis, Microsoft Access MVP "AccessIM" wrote: 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? |
#3
|
|||
|
|||
Pop Up Form Question
"Klatuu" wrote in message
... 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. -- Dave Hargis, Microsoft Access MVP 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. |
#4
|
|||
|
|||
Pop Up Form Question
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/comm...ss.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 "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "AccessIM" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|