Pop Up Form Focus Question

A

AccessIM

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?
 
M

Mr. B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pop Up Form Focus Question 1
Pop Up Form Focus Question 1
Pop Up Form Question 3
Pop Up Form Focus Question 2
Pop up window?? 5
Close on Lost Focus 2
Pop up form 2
Macro doesn't work first time form is opened. 2

Top