Datashhet View from another Form wont work

  • Thread starter Thread starter Confused87
  • Start date Start date
C

Confused87

I have a form which opens in Datasheet View, but then I have a command button
in another form and it only will open in form view. How do I get it to open
as a datasheet? I have gone to Properties and set Datasheet to yes and
everything else to no but it has made no difference. Here it is:



Option Compare Database

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "LINDEN Address Searching"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub


Any ideas?
Cheers
C
 
I have a form which opens in Datasheet View, but then I have a command button
in another form and it only will open in form view. How do I get it to open
as a datasheet? I have gone to Properties and set Datasheet to yes and
everything else to no but it has made no difference. Here it is:

Option Compare Database

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "LINDEN Address Searching"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub

Any ideas?
Cheers
C
Click to expand...

Regardless of a form's Default View setting, if you wish to open that
form in Datasheet View using code you must specify Datasheet View.

DoCmd.OpenForm stDocName,acFormDS, , stLinkCriteria
 
perfect, thanks (very new to this)

fredg said:
Regardless of a form's Default View setting, if you wish to open that
form in Datasheet View using code you must specify Datasheet View.

DoCmd.OpenForm stDocName,acFormDS, , stLinkCriteria
Click to expand...
 
Back
Top