Issues while maximizing or restoring forms

[Ricardo de Mila]

Dear Bytes community, good afternoon...
It can appear to be a very sily question, but I'm having problems while trying to restore the size of a form.

In my case I have already a form opened and maximized and when I click over a control I want a second form to be opened. But this second form must be sized as "Restored" and the first one must be kept as "Maximized" .

What is happening is that when I restore the second form, the first form is also restored. I want a restored form over a maximized form.

Can any body give me a tip about what my problem is?
I'm just using the instruction DOCMD.OPENFORM to open the second form and the instruction DOCMD.Restore to restore it.

Thank you in advance.

Best regards
Ricardo de Milano

[twinnyfo]

Ricardo,

Unfortunately, this is less of a "problem" and more of simply how Access works with Forms. When you maximize any form, you are maximizing the application, as well. The same goes for restoring. Thus your problem.

You might be able to have the second form operate in modal and popup, without using the Restore command. I have not tested this, so you would have to do that. I typically use all modal and popup forms and only maximize when displaying reports.

An alternative, which would be more involved is to have the first form determine the screen size of the current user, then, resize itself to fill the screen (without maximizing) and then opening the second form.

Part of me wonders why the first form must be maximized? If it is simply a larger form, and sized appropriately, all should work without maximizing it.

Hope this hepps!

[Ricardo de Mila]

Dear twinnyfo...

Thank you for your valuable help.
I have understood your explanation and will test your options.
As soon as I have an exactly feedback I will post it here.

To satisfy your curiosity about why should the first form still be maximized, the explanation is:
The first form is a list of contacts with phones and e-mails etc. But the phone numbers can be showed in several formats (each phone). I can have them displayed as +# ### ###-#### or +## ## ####-#### or simply ## ####-#### or any other. So the field can not have just a mask on it. I have the field as a formula. But because of this I cannot enter the phone number in the field directly. So the solution I have found was to open a second form where the phone number will be inputed. So when the user enters in the specific control, the second form opens up. But in this case, I don't want the first form to be changed due to visual effects that would not be nice.
Hope I have satisfied your question.

Will experiment your suggestions and let you know.

Best regards
Ricardo

[twinnyfo]

If that is the case, you could just make the other form a sub-form that is invisible on the main form and when someone needs to enter a phone number it becomes visible, and when they are done, it becomes invisible again and updates the main form.

Lots of ways to skin your particular cat!