onLoad View as Datasheet

[Dummy]

hi

i have created subforms and set the Default View to Datasheet
Now i have a form where i am adding command buttons on it to load those subforms but They are not Loading it as DATASHEET VIEW.
Any Clue?

Thanks

 

[Mile-O]

Have you set their DefaultView to DataSheet also?

 

[Dummy]

yes sir, i am surprised why

 

[Dummy]

check the attached file...its a stupid thing...but in all cases u know my name hehe

 

[adevera]

I change to docmd command and it work the way you want..



Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "subform"
DoCmd.OpenForm stDocName, acFormDS 'the acFormDS tells the form how to open your subform in datasheet view

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub

 

[Dummy]

thanks