Open forms & queries from Maximized form

[netrusher]

I currently have a database that opens to a form in maximize view. What I
want to do is open other Forms or Queries from this form in maximize view but
do not want the other forms or queries to open in maximize view.

How can I do that?

 

[genomon]

What I want to do is open other Forms or Queries from this form in maximize view but do not want the other forms or queries to open in maximize view.

Which is it going to be?

"Business conventions are important because they demonstrate how many people a company can operate without."

 

[netrusher]

Hard to understand the way I wrote it. What I am saying is
I want to open other forms and queries from the form that is
in maximize view. I do not want any other forms or queries
in maximize view when they open from the form that is already
in maximize view.

Thanks

 

[genomon]

DoCmd.OpenForm acNormal?

"Business conventions are important because they demonstrate how many people a company can operate without."

 

[genomon]

OOPS.
DoCmd.OpenForm "yourformname", acNormal?

"Business conventions are important because they demonstrate how many people a company can operate without."

 

[genomon]

Also this may be helpful, from Access help files:

Restore Action


You can use the Restore action to restore a maximized or minimized window to its previous size.

Note This action cannot be applied to module windows in the Visual Basic Editor (VBE). For information about how to affect module windows see the WindowState property topic.

Setting

The Restore action doesn't have any arguments.

Remarks

This action works on the selected object. If an object has been minimized, you can first select it by using the SelectObject action and then restore it to its previous size by using the Restore action.

You can use the MoveSize action to move or size a window that you've restored.

The Restore action has the same effect as clicking the Restore button in the window's upper-right corner or clicking the Restore command on the window's Control menu.

To run the Restore action in Visual Basic, use the Restore method of the DoCmd object.

"Business conventions are important because they demonstrate how many people a company can operate without."

 

[netrusher]

Thanks,

How about queries?

 

[genomon]

This action works on the selected object.

Doesn't matter what the object is.


"Business conventions are important because they demonstrate how many people a company can operate without."