Datasheet View

[Sash]

I created a form in datasheet view. However, when I open this form from some
VB code on another form, it opens as a regular form.

Dim stFormPT as string
stFormPT = "ErrorPT"
Docmd.OpenForm stFormPT

 

[bcap]

Docmd.OpenForm stFormPT, View:=acFormDS

 

[Steve]

Try DoCmd.OpenForm strFormPT, acFormDS

 

[Linq Adams via AccessMonster.com]

As bcap and Steve have shown, when opening a form in Datasheet view from
another form, you have to explicitly open it in Datasheet view, regardless of
how the default view is set for the form on its own. BTW, both syntaxes given
are correct.