Datasheet view

[PeteJM]

Hi, I have some forms in my database that are in Datasheet view. These open fine wheni open them directly but when i open them from a command button they only open as a single record.

Is there a way i can get them to open in datasheet view from the command button.

Regards

Pete

 

[scouser]

Hello

Hello. Put the following on your command button:

Private Sub cndOpenForm_Click()
On Error GoTo Err_cndOpenForm_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "YOURFORMNAMEHERE"
    DoCmd.OpenForm stDocName, acFormDS, stLinkCriteria
        

Exit_cndOpenForm_Click:
    Exit Sub

Err_cndOpenForm_Click:
    MsgBox Err.Description
    Resume Exit_cndOpenForm_Click
    
End Sub

Regards,
Phil.

 

[PeteJM]

Thank you

Thank you very much for your help.

Regards

Pete