Problem with Form Size

[Tanya]

Hi
My main form has the following command line

DoCmd.Maximize

Which is exactly what I want. BUT I have added a text box with a macro to open another form to enable adding data to a combo box and the problem is it keeps opening in maximize mode. I think this is related to the fact the main form is set to do this.

Does anyone know a way around this?


Also::
When I use other command buttons the main form is no longer maximized which is really annoying.

Can anyone help please?

Thanks in advance
Tanya

 

[boblarson]

If you maximize one thing, the everything gets maximized. If you use DoCmd.Restore it will set all objects back to their normal size. That is just the way it happens. If you have a main form maximized and want to open another form, not maximized, then you would need to open it as a popup form.

 

[Tanya]

Thanks for the idea.

I have since solved the problem.

The problem related to the macro, I changed the window mode to dialog.

cheers
Tanya