View Full Version : Display Records in Datasheet View


crhodus
10-18-2001, 06:43 AM
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
10-18-2001, 07:25 AM
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
10-18-2001, 10:01 AM
Thanks! That fixed my problem.