DataSheet view problem

[Guest]

I have several forms that I open from a switch board button. I can not get the forms to open in datasheet view.The default etc are set to datasheet but they open in single form view,when i open the form by double clicking directly on it it opens ok in datasheet.
If after opening the form I change to design view then back it opens in datasheet.

 

[Ken]

-----Original Message-----
I have several forms that I open from a switch board

button. I can not get the forms to open in datasheet
view.The default etc are set to datasheet but they open in
single form view,when i open the form by double clicking
directly on it it opens ok in datasheet.

If after opening the form I change to design view then back it opens in datasheet.
.

Set the forms Default view to Datasheet and the Views
allowed to Datasheet

 

[Guest]

I have done that Ken but the forms all still open in single view. note this only happens when the form is opened from a button.
This is the code generated for the on click

Private Sub All_Forward_Click()
On Error GoTo Err_All_Forward_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Crane form All"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_All_Forward_Click:
Exit Sub

Err_All_Forward_Click:
MsgBox Err.Description
Resume Exit_All_Forward_Click

End Sub

 

[Joan Wild]

I have done that Ken but the forms all still open in single view.
note this only happens when the form is opened from a button. This is
the code generated for the on click

DoCmd.OpenForm stDocName, , , stLinkCriteria

Change that to

DoCmd.OpenForm stDocName, acformDS, , stLinkCriteria