Size of Form window

[jamil_786]

Dear freinds,
I have a main form in my Database and i made another form that is opened with a command button from main form. I have a question that i want to open the form that is opened with command button from main form in small window so that i'll be able to see the information of main form also. I do not want to minimize the form window with drag.
Please advise me...
Thanks..

 

[DCrake]

Make the sub form a Model Popup type form - see form properties. This will ensure that the form being opened is always on top of any other open forms.

 

[jamil_786]

Thanks DCrake for your reply.
Freind i did as you mentioned in your reply the form is opening in popup but it is same in maxmize window as the main form window. I want the form will open in a small window than my main form window.

 

[DCrake]

Either you are using the DoCmd.Maximize setting or your Auto resize setting is wrong.

 

[WayneRyan]

Jamil,

Look at the DoCmd.MoveSize command.

You can put that in your form's OnOpen event and it'll open with the
proper size and location.

Wayne

 

[WayneRyan]

Jamil,

p.s. As suggested, you should still make it modal.

Wayne