I've never quite mastered what makes Access Forms tick. (Compared to nice sensible Excel ones!)
I have one which is really irritating.. it opens with this line
Code:
DoCmd.OpenForm "frmMove", acWindowNormal, , , , acDialog, RetVal1
Most of the time it's OK. But sometimes while developing & testing some code, it can open full screen rather than as a small window on top of other stuff (which is what's wanted).
Both Popup and Modal properties are set No. (Although acDialog means modal, yes ?)
Is there anything I can do to make the Form to always Open as I want it, no matter what ?