Form not positioning properly on screen

[Eric G]

I have a form that opens when a button is clicked on its parent form.
If I open the parent form from the DB window, and then click the
command button the form opens in the right place on the screen,
superimposed upon the parent form.

If I open the parent form by simply opening the db and letting the
autoopen do its thing, and then click the command button, the form
opens a half inch or so just above the parent form.

Can someone please tell me some of the things I should check/do to
correct this?

I have auto resize and auto center set to no.
Pop-up no, modal no.

Thanks! Eric

 

[John Viescas]

Eric-

It probably has something to do with your Startup properties and the code
you have in your startup form or your AutoExec macro. Are you
hiding/showing toolbars? When you don't use AutoCenter, Access saves an
internal "left" and "top" location property relative to the Access workspace
(the blank area below the toolbars) -- the location the form was on the
screen when you last saved it. If some menu bar or toolbar is hidden when
the form opens, it'll appear to open higher on the screen than normal. If
some extra toolbar is open, it'll open lower. So, it could be that the
first form is opening in a lower position than you expect (perhaps because
some toolbars are in the process of closing at startup). The simplest
solution is to save the second form in a location a bit lower that where you
actually want it -- or the first form in a higher position.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[Eric G]

Hi John,

Thanks very much for these tips!
I've re-positioned the second form and it seems to have solved the
problem. Eric