Display Records in Datasheet View

[crhodus]

How can I get my form to display records in datasheet view? When I launch the form from my switchboard, it loads it in Form View. I tried changing the Default View and Views allowed to Datasheet View, but this didn't help.

Thanks!

 

[DJN]

This will open your form in datasheet view. I am assuming that you want to open that way all the time.

Dim stDocName As String

stDocName = "YourFormName"

DoCmd.OpenForm stDocName, acFormDS, "", "", , acNormal

 

[crhodus]

Thanks! That fixed my problem.