form opening in single form - need datasheet

[ste4en]

I am trying to open a form in datasheet format from a button. Even thoug the form itself is set to datasheet view it opens as a single form. I suspect I need to add something between the commas on the Do.Cmd statement, but what?


Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmwp"
DoCmd.OpenForm stDocName, , , stLinkCriteria


Thanks

 

[jazzz]

Here you go:

DoCmd.OpenForm strDocName, acFormDS,,stLinkCriteria

In the properties for the form make sure on the Format Tab you have views set to both.

Life's a journey enjoy the ride...

jazzz

 

[ste4en]

Thanks