Opening Forms

I have created forms based on a query. Everything works perfect except that
everytime I run the query my form opens up to the full screen view. I have
designed the query form such that when it opens it opens in the middle of the
screen (restore down view). Purely asthetic, I know. As it is when the form
opens it opens in the maximize screen view unless the overall database is in
the restore down view in which case the query forms open the way I want them
to. This does not serve my purpose.

Is there anyway of setting each query form so it opens in the restore view
everytime no matter if the main databse form is in the maximize view.

Thanks

Scott

add the following code to the form's OnLoad event procedure, as

DoCmd.Restore

hth


"Srowe" wrote in message
...
I have created forms based on a query. Everything works perfect except
that
everytime I run the query my form opens up to the full screen view. I have
designed the query form such that when it opens it opens in the middle of
the
screen (restore down view). Purely asthetic, I know. As it is when the
form
opens it opens in the maximize screen view unless the overall database is
in
the restore down view in which case the query forms open the way I want
them
to. This does not serve my purpose.

Is there anyway of setting each query form so it opens in the restore view
everytime no matter if the main databse form is in the maximize view.

Thanks

Scott