Datasheet Form (1 Viewer)

[casey]

If I design a form to display data in the datasheet view, why does it show up in a different view when I open it in my program?
Any thoughts?

 

[casey]

More specifically...

Does anyone know the correct syntax for using the OpenForm command to open a form in the datasheet view?

 

[mark curtis]

Go to the form properties in desgin view and set the default view to datasheet.

 

[casey]

I tried that and the form still opened in "Normal" mode. Wierd huh? I finally figured out how to use the command properly. The acFormDS property did the trick.

Dim stDocName As String
stDocName = "frmAddCat"
DoCmd.OpenForm stDocName, acFormDS
' ******
That seems to work, but it's wierd that changing the property didn't do it.

Thanks Mark.