DoCmd.RunCommand acCmdxxxxx makes form disapear?

[1DMF]

hi,

I'm trying to perform a 'restore down' command against the main DB shell.

I've tried

DoCmd.RunCommand acCmdReset
DoCmd.RunCommand acCmdRestore
DoCmd.RunCommand acCmdZoom100

but all that seems to happen is the open form vanishes and i'm left with just a blank DB shell.

why is this happening and how do I perform the desired action.

Thanks,
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta

 

[1DMF]

It's ok, i was given the wrong constant names!

this is the correct syntax

    DoCmd.RunCommand acCmdAppMaximize
    DoCmd.RunCommand acCmdAppRestore

Not sure why the other commands made my form invisible, another Access quirk I guess?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

MIME::Lite TLS Email Encryption - Perl v0.02 beta