View Full Version : Datasheet Form


casey
02-09-2001, 08:00 AM
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
02-09-2001, 09:04 AM
More specifically...

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

mark curtis
02-09-2001, 10:03 PM
Go to the form properties in desgin view and set the default view to datasheet.

casey
02-10-2001, 09:09 AM
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.