form not opening in datasheet view

[Troy]

I have a form I designed in datasheet view. Everything is great until I
open it with a command button I did through the wizard. How do I force the
form to open in datasheet view?

Thank you,

Troy

 

[Jeff Conrad]

Hi Troy,

If you do not specify a View argument in the OpenForm method, then acNormal is assumed (which is
normal form view). You need to add the acFormDS argument. Adjust your OpenForm code to something
like this:

DoCmd.OpenForm "Name Of Your Form Here", acFormDS

However, if by "wizard" you mean you are opening this form from the built-in Access Switchboard
Manager, then that changes things. If this is true, post back and I'll give further instruction.

 

[Troy]

worked like a champ Jeff, thanks a million! I felt like it was in the
DoCmd, but I didn't know what the syntax was. Speaking of which, is there
a site with all the commands listed?

thanks again,

Troy

 

[Jeff Conrad]

You're welcome, glad I could help.
This site has an extensive list of the RunCommand constants:

http://www.tkwickenden.clara.net/

That's probably not exactly what you are looking for.

You can also try searching the Help files for DoCmd and you should get more information there. With
Access 97 I can click on the "Methods" link of the DoCmd Object help file and bring up a list of
additional help topics associated with DoCmd.