How make screen restore after docmd.openquery that is set to maximize
Posted on 2013-12-05
I have a command button on a form which opens a query. Here is the code:
DoCmd.OpenQuery "qryMemberLists", acViewNormal, acEdit
But when the user close the query I want the form that launched it to be restored to it's original size. I tried docmd.restore on the form's on got focus event but that doesn't work.
Can this be done?