[RESOLVED] Set the startup position of a form

Is there a way in Access to make a form startup in a position other than automatically centered? Ideally, what I would like to do is have the form get the position of the form it is opened from and then position itself say 20 pixels down and to the left of the parent form.... any help much appreciated. vbforums is a lifesaver !!

Thats sounds like you want Cascading Window layout?

Yes! Thats it exactly. I thought it would be quite easy to do but I have to admit its got me stumped.

I'm just getting ready to start installing Office 2003 SP2 on my system, had to reinstall eveerything after a hd failure.

Give me a few more minutes to install it and I will whip up some code for you.

You are a legend my friend!

Flattery will get you everywhere! :blush: :D

Hey, if all you want to do is cascade the windows, have you tried this?

docmd.RunCommand acCmdWindowCascade

if you want more control there is another way but i can't seem to remember it right now

:lol: Just finished installing and you beat me to it. :thumb:

VB Code:

Public Function CascadeMe() As Boolean
    On Error GoTo MyError
    Application.DoCmd.DoMenuItem acFormBar, 4, 1
    CascaseMe = True
    Exit Function
MyError:
    CascadeMe = False
End Function

hey, thats great, thanks guys. :)