Open form in datasheet view

[Guest]

Quick question;

I have a form (#1). I made a button on form #1 which, when clicked, will
open another form (#2). Form #2 is supposed to open in datasheet view. It
does, when I click directly on the form. However, when I click on the button
in form #1, form #2 opens in a form view. How do I make it open in a
datasheet view?

Casa

 

[Guest]

DoCmd.OpenForm "FormName", acFormDS

 

[Douglas J Steele]

DoCmd.OpenForm "NameOfForm", acFormDS

The default view with the OpenForm method is acNormal, which will override
the form's settings.

 

[Guest]

Thanks for the help. It worked!

DoCmd.OpenForm "NameOfForm", acFormDS

The default view with the OpenForm method is acNormal, which will override
the form's settings.